Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


skipunda

Recommended Posts

Posted

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!?

Posted
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.

Posted
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

Posted

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.

Posted
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

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Posted
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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...