skipunda Posted April 17, 2009 Posted April 17, 2009 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 Posted April 17, 2009 Posted April 17, 2009 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 Posted April 17, 2009 Author Posted April 17, 2009 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 Posted April 17, 2009 Posted April 17, 2009 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 Posted April 17, 2009 Posted April 17, 2009 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
skipunda Posted April 17, 2009 Author Posted April 17, 2009 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 Posted April 17, 2009 Posted April 17, 2009 Output Queries Debug Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here]
Recommended Posts
Archived
This topic is now archived and is closed to further replies.