Navigation

Building on top of existing benchmarking infrastructure, here I show how to count number of SQL queries a page generated.

1. Add SQL query counter in benchmark_setup.txt

global $SQLQCount;
$SQLQCount = 0;

2. Inclement the query counter in sql_query() (@nucleus/libs/globalfunctions.php)

   function sql_query($query) {
     global $SQLCount;
     $SQLCount++;
     $res = mysql_query($query) or print("mySQL error with query $query: " . mysql_error() 
            . '<p />');
     return $res;
   }
   

3. Show the Count at the end after the page is processed (from benchmark.txt)

  global $SQLCount;
  printf("%d SQL queries recorded<br />", $SQLCount);

Note, there are some limitation with this method; The total query count does not register those query by mysql_query directly. Actually, many plugins do this.... which need to be fixed. Also, the queries done by Nucleus is not take into account.