Queries?

[La_Parka]

Is there a script that displays a number of queries a page is taking up? If so please link me to it. Thanx

[bretticus]

Wassup Homee!

displays a number of queries a page is taking up

queries a page is taking up???

[La_Parka]

Originally posted by bretticus
Wassup Homee!



queries a page is taking up???

Like Mysql queries a page uses to load........

Pardon my english

[bretticus]

So, if I'm understanding you, you have a script that uses a MySQL query to return x number of records and you want to know how many??? You really need to be MUCH more specific

[La_Parka]

Originally posted by bretticus
So, if I'm understanding you, you have a script that uses a MySQL query to return x number of records and you want to know how many??? You really need to be MUCH more specific

I want a script that displays in plain text "This page took X queries to generate." Specific enough for you?

[edwardsbc]

This is a nice feature Cold Fusion has that PHP doesn't. What I do is create a global variable to keep the count, and just increment it everytime I do a query.

$r=odbc_exec($h,$sql); $GLOBALS['querycount']++;

I actually have this as a macro in my editor.

[bretticus]

I think that's just kinda standard syntax ...

$result = mysql_query($query); $query++;

isn't that the same thing?

[bretticus]

better revise that so my $query varibale is not the same as the count variable:

$result = mysql_query($query); $query_count++;