Number of queries 1

[4x4uk]

I have seen a couple of sites using php/mysql, particularly forum boards which display a query count and processing time at the bottom of the page. Any ideas on how this is done.
Many thanks
Ian

Infinity exists! - I just haven't worked out a way to get there yet.

http://www.ne4x4.org.uk/

|

http://www.ne4x4.org.uk/Ian/

|

http://www.ne4x4.fsnet.co.uk/beck/

 

[iza]

what do you mean with "number of queries" - do you mean the number of returned results for a given query (then the explanation on it + processing time can be found here

http://www.php.net/manual/en/ref.mysql.php)

or the number of queries you can send (then you're supposed to know it ... ) ?

 

[4x4uk]

If you take a look at the following page right at thye bottom it gives what I assume is the number of queries performed and the time taken

http://www.xmbforum.com/community/boards/

Regards
Ian

Infinity exists! - I just haven't worked out a way to get there yet.

http://www.ne4x4.org.uk/

|

http://www.ne4x4.org.uk/Ian/

|

http://www.ne4x4.fsnet.co.uk/beck/

 

[sleipnir214]

I would think that the numbers presented are the number of queries used to produce the output you see.

In your script:
Start a timer. Count the number of queries. Stop the timer. Report the results.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[4x4uk]

Sleipnir214
Many thanks and congrats on being made tipmaster of the week
Regards
Ian

Infinity exists! - I just haven't worked out a way to get there yet.

http://www.ne4x4.org.uk/

|

http://www.ne4x4.org.uk/Ian/

|

http://www.ne4x4.fsnet.co.uk/beck/