Is there a website / software to measure amount of SQL queries per page

[skipunda]

Hi,

 

What tools are available to measure the number SQL connections or queries in any given website page? I often see on here people noting how many queries they have and what to do about it but short of reading the source code I can't see how they get this information.

 

Am I missing a piece of software in my library!?

[Hotclutch]

Hi,

 

What tools are available to measure the number SQL connections or queries in any given website page? I often see on here people noting how many queries they have and what to do about it but short of reading the source code I can't see how they get this information.

 

Am I missing a piece of software in my library!?

 

In Admin - Configuration - Logging

 

Set Show database queries to true, AND display the page parse time to true.

 

Then view the foot of the page you want to check.

[skipunda]

In Admin - Configuration - Logging

 

Set Show database queries to true, AND display the page parse time to true.

 

Then view the foot of the page you want to check.

 

phew, i'm glad I used the test database to try that out with. The test site gave me this

 

Warning: error_log(/var/log/www/tep/page_parse_time.log) [function.error-log]: failed to open stream: No such file or directory in C:\xampp\htdocs\catalog\includes\functions\database.php on line [xx]

 

Thanks for your assistance. I'll read around this now

[Guest]

It just means it can't find the file /var/log/www/tep/page_parse_time.log so create a log file and make sure it point to the correct place.

[Jack_mcs]

Hi,

 

What tools are available to measure the number SQL connections or queries in any given website page? I often see on here people noting how many queries they have and what to do about it but short of reading the source code I can't see how they get this information.

 

Am I missing a piece of software in my library!?

Take a look at this thread.

 

Jack

[skipunda]

Take a look at this thread.

 

Jack

 

Yes your right, I can see I dont have a www folder so this must have come down from the server. Will probably have to edit a field in the SQL database to point to a new folder.

 

nice one jack, i've already seen that thread but didn't know there was anything in it to actually show how many. Still a good read though and i'll be sure to implement some of the ideas.

 

ta

skip

[♥toyicebear]

Output Queries Debug