Originally Posted by lab55
When your Query Time is almost as large as your Parse Time, it means your MySQL server is taking forever to retrieve your data, and thus it needs some serious tuning by the server administrator. Either by fixing memory allocations and cache settings, or even by just ensuring that all the indexes originally set are actually still in place. And if the server's hard drives are running out of space allotted to MySQL, that should be fixed as well.
Results 1 to 8 of 8
Threaded View
-
14 Nov 2008, 08:20 AM #6
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
Re: huge store running slow!!!!!! 413,000 products
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
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.
Similar Threads
-
v138a catagory running slow
By ste griff in forum General QuestionsReplies: 2Last Post: 7 Jan 2013, 01:12 AM -
30,000+ products.. Slow speed, suggestions?
By z3n in forum General QuestionsReplies: 5Last Post: 20 Dec 2009, 04:16 AM -
Store Running Slow
By mviben in forum Templates, Stylesheets, Page LayoutReplies: 10Last Post: 29 Jun 2008, 02:35 AM -
My store is running Slow...
By picard1701 in forum General QuestionsReplies: 2Last Post: 14 Jan 2008, 10:30 AM -
Site's Search engine is very slow for site with 40,000 products
By catv in forum General QuestionsReplies: 19Last Post: 9 Jun 2007, 12:28 AM
