Query Count

[TheMayhem]

I am extremely interested in counting the number of queries I execute per page as I figure if I can limit the amount of queries then I can naturally decrease server load and increase page execution time. I found this post but really have no clue what they are talking about...

http://www.phpbuilder.com/board/showthread.php?threadid=10284923&highlight=queries+executed+per+page

What exactly do I need to do to count the queries executed?

[mrhappiness]

They are talking about not using mysql-query directly but using a class handling all your database stuff.

short (and not working) example that should show you the right way:

class my_db_layer {
  var $queries_executed = 0;

  function query($sql) {
    $this->queries_executed++;
    return mysql_query($sql);
  }
}

$my_db_object = new my_db_layer();

$r1 = $my_db_object->query('SELECT * FROM users');

echo $my_db_object->queries_executed.'<br />';

$r2 = $my_db_object->query('INSERT INTO visits (visit_time, page_id) VALUES (NOW(), 5)');

echo $my_db_object->queries_executed.'<br />';