I've sent PM to You.
The problem was that I neglected to set the second two entries to true after I set the 'QC_USE_PRODUCT_QUERY_DETECTION' to "FALSE"
The site screams now because of your mod!!!!
Dude you rock!!!
Check this out!!!!!!!
(This is down from way over 1000!
And this is even on a GoDaddy server!
Parse Time: 3.387 - Number of Queries: 230 - Query Time: 0.34338080839539
After I made the changes the site was fast for awhile then it slowd way down again. I am really beginning to wonder if I am on one of GoDaddy's overloaded servers and maybe this is the problem.
I am reading up on Gzip compression and how to use hoping maybe it will help. Something has to give or I will be forced to move my site off of their hosting service.
Is there a sure way to verify that their server is the issue because when I call them they say that everything is fine and that the problem MUST be my site.
This is what I am getting now:
Parse Time: 40.772 - Number of Queries: 243 - Query Time: 3.3197158103485
Parse Time: 40.772 << regardless of what you do, this indicates an overloaded Server
The learning is in the doing.
My next call is to GoDaddy. If they cannot cure the issue then I will be moving my site.
Could you or someone pm me with some hosting suggestions?
There is a list of hosting suggestions here: http://www.zen-cart.com/index.php?ma...es&pages_id=10
Zen Cart - putting the dream of business ownership within reach of anyone!
Donations always welcome: www.zen-cart.com/donate
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
I installed this, didn't seem to make much difference so I uninstalled it and restored the two files it overwrote, now I am getting this:
Can anyone help me fix this asap please?Code:1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_SHOW_PRODUCT_INFO_MAIN' at line 1 in: [SQL_SHOW_PRODUCT_INFO_MAIN]
Just put the store down for maintenance and have this in bottom right corner now
Code:1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_BANNER_CHECK_QUERY' at line 1 in: [SQL_BANNER_CHECK_QUERY]
Hi again, took a break from the pc, figured since all the other posters here had really good results that it had to be a fault on my end not to get much difference the first time (I prolly missed uploading a file with my track record today LMAO), so took a break and re-uploaded LOL
Parse Time: 1.151 - Number of Queries: 597 - Query Time: 0.0619792304688
Parse Time: 1.436 - Number of Queries: 260 - Query Time: 0.320205312271
which is great! Thank you :)
I don't think it's that great at all ;). Parse times jumped from 1.1 to 1.4 sec. Try to switch off QC_USE_PRODUCT_QUERY_DETECTION (set it to FALSE) in includes/extra_configures/query_cache.php .