View Full Version : 2 questions here
Clive
06-26-2003, 01:13 PM
1) how do I count queries executed? I heard I had to use class on it but I dunno how, could someone please give me a sample code for it?
2) I had one mysql_query(); code on my script, and 4 mysql_result(); code on it. How many queries did the script executed? I mean, is the mysql_result(); function counted as a query?
thanks
filburt1
06-26-2003, 01:41 PM
Each call to mysql_query() generates one query (so $DB_site->query() and $DB_site->query_first() each generate one query).
Only if this is a testvb, add $debug=1 to config.php, then tack &explain=1 onto the URL of the page you want to check.
If it's your own page, either use the included DB_mysql.php file and its DB_site class, or write your own wrapper one.
Clive
06-26-2003, 01:52 PM
errr, tis has nothing to do with vb :( I'm making my own script, I had too many mysql_results(); on my script and I wanna know if it will slow down the server load. (I wanna know how many queries did the script executed too)
filburt1
06-26-2003, 04:45 PM
mysql_result() doesn't use any more queries or significantly increase server load.
Clive
06-27-2003, 02:50 PM
nice. So how can I count the queries executed?
Gary King
06-27-2003, 08:48 PM
Maybe have a function like this:
function query($query)
{
global $querycount;
$sendquery=mysql_query($query);
if ($sendquery)
{
$querycount++;
}
}
And use query instead of mysql_query. It will add 1 to $querycount everytime you use a query :)
Clive
06-28-2003, 05:12 PM
and I'll just echo $querycount out? thanks!
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.