The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
2 questions here
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 |
#2
|
|||
|
|||
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. |
#3
|
||||
|
||||
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)
|
#4
|
|||
|
|||
mysql_result() doesn't use any more queries or significantly increase server load.
|
#5
|
||||
|
||||
nice. So how can I count the queries executed?
|
#6
|
||||
|
||||
Maybe have a function like this:
PHP Code:
|
#7
|
||||
|
||||
and I'll just echo $querycount out? thanks!
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|