X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fdb%2Flib-mysql3.php;h=459eca4e69c020a558e3ae737cbbd1e921d89838;hb=5e9e2e145dc720e1459a6f1f51f2a32f1fcc9b6d;hp=206c868f5ad13ef9b9c4d1c75835de53bae2d99f;hpb=229c7f934f0976dee3cf2908ebf526ba503c7857;p=mailer.git diff --git a/inc/db/lib-mysql3.php b/inc/db/lib-mysql3.php index 206c868f5a..459eca4e69 100644 --- a/inc/db/lib-mysql3.php +++ b/inc/db/lib-mysql3.php @@ -137,9 +137,15 @@ function SQL_NUMROWS ($resource) { $lines = false; // Is the result a valid resource? - if (is_resource($resource)) { + if (isset($GLOBALS['sql_numrows'][$resource])) { + // Use cache + $lines = $GLOBALS['sql_numrows'][intval($resource)]; + } elseif (is_resource($resource)) { // Get the count of rows from database $lines = mysql_num_rows($resource); + + // Remember it in cache + $GLOBALS['sql_numrows'][intval($resource)] = $lines; } else { // No resource given, please fix this debug_report_bug(__FUNCTION__, __LINE__, 'No resource given! result[]=' . gettype($resource) . ',last_sql=' . $GLOBALS['last_sql']); @@ -171,7 +177,7 @@ function SQL_FETCHROW ($resource) { } // SQL fetch array -function SQL_FETCHARRAY ($res, $nr=0) { +function SQL_FETCHARRAY ($res) { // Is a result resource set? if ((!is_resource($res)) || (!SQL_IS_LINK_UP())) return false;