Post by Qphoria » Fri Oct 29, 2010 8:44 am

This mod adds a time check around the db query call to show exactly how long database queries are taking so you can track down potential slow queries on your server. This should create a file in the root of your store called "query_time.txt"

This will log all db queries that are called when a page is refreshed like this:

Code: Select all

--- PAGE URL: route=checkout/cart ---

[index.php]
Query Time: 0.0078 :: SELECT * FROM setting
Aggregate: 0.0078

[index.php]
Query Time: 0.0016 :: SELECT * FROM language
Aggregate: 0.0108

[system/library/currency.php]
Query Time: 0.0019 :: SELECT * FROM currency
Aggregate: 0.0127
After each page load, refresh the file directly from the url:

Code: Select all

http://yoursite.com/query_time.txt 
Times should be low in most cases. No more than 0.0050 I would say and even that should only be for very large queries

Attachments

OpenCart 1.5.x

OpenCart 2.x


Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by kedgetech » Fri Oct 29, 2010 11:18 am

Good One Q ! should be handy for troubleshooting.

User avatar
Active Member

Posts

Joined
Mon Mar 22, 2010 5:20 pm
Location - USA, Australia, India

Post by Qphoria » Sun Apr 24, 2011 10:25 pm

Xsecrets wrote:looks like yes he has alot of categories, but also LOTS of products. I think you need to look at my performance optimization thread. http://forum.opencart.com/viewtopic.php?f=24&t=24391 I think those changes would help you quite a bit as the product query is taking over 4 seconds.
Just use the vQmod script for it here:
http://forum.opencart.com/viewtopic.php ... 91#p126611

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Qphoria » Thu Apr 07, 2016 5:05 am

Updated to add a 2.x version

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by pwuy » Thu Apr 07, 2016 5:43 am

Hi dude, im trying to install this, but it returns me "invalid format".

Can you help me? Thanks a lot!

Newbie

Posts

Joined
Tue Apr 05, 2016 11:51 pm

Post by Johnathan » Thu Apr 07, 2016 10:16 pm

This is a vQmod file, not an ocMod file. You'll need to install vQmod from vqmod.com first, then you can upload it to the /vqmod/xml/ folder.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by pwuy » Fri Apr 08, 2016 12:23 am

Hi Johnathan, thanks for your reply.

query file shows only this: --- PAGE URL: route=product/category&path=60 ---

My problem is detailed here: viewtopic.php?f=190&t=160554

Do you have any idea of what can be happening? Thanks for your help!

Newbie

Posts

Joined
Tue Apr 05, 2016 11:51 pm

Post by bibiloute » Mon Sep 26, 2016 5:36 am

Hello,

How can i use it for track queries when i click on checkout confirm button.
My site is now very fast except the last step when i click on confirm button it take about 25second to reach the payment gateway it's not good at all im losing order because of this so if i can track what take this much time it would be fantastic

thanks.

Newbie

Posts

Joined
Wed Oct 02, 2013 10:45 pm

Post by dharam81 » Thu Oct 13, 2016 5:15 pm

Hi,

I am trying to use this for 1.5.6. while I refresh the page

it only display as :

--- PAGE URL: route=checkout/cart ---
--- PAGE URL: route=product/product/add --- etc and this keep changing but no query result display.

am I missing any thing?

Active Member

Posts

Joined
Mon Apr 30, 2012 8:26 pm

Post by saliverdim » Sun Feb 19, 2017 1:34 am

my website .txt not open :/ but robots.txt its works.
I don't now can you help me ? not found page all txt files :((

Active Member

Posts

Joined
Wed Oct 07, 2015 12:15 am

Post by saliverdim » Thu Mar 09, 2017 2:31 am

blank page can yoo help me

Active Member

Posts

Joined
Wed Oct 07, 2015 12:15 am
Who is online

Users browsing this forum: No registered users and 3 guests