Our admin pages have suddenly become very slow to load. I've checked the server usage and we're well below limits. Also the front end seems to be ok. Does anyone have any ideas?
Check what 3rd party addons you have that might be making remote calls to sites that may not be responding (like Twigmo).
Add "?debug" to the URL in the admin panel. Check SQL section in the debugger. May be you have some incorrect sql queries
I'm seeing this query in the SQL section but it takes almost a second to finish. Do you understand the logic behind running this type of crazy query to load admin panel page?
It's really not that crazy a query if you break it down. Effectively it is getting a listing of products based on your company_id for those products that are unique to your storefront and that are shared between storefronts..
How many products do you have? This query should take a second.
Do you have adequate memory on your server to support the high demands that cs-cart places on mySQL?
Do you have fast disks (SSD) so that indexes are read quickly?
It takes 0.3 seconds just for this query for 10 products only. I have 3300 active products at the moment. I have only one storefront so not sure if it is even necessary.
The server has 8GB memory and Mysql has configuration to go up to 6.5 GB memory. The whole server hardware has been dedicated to one website. You hit the nail on SSD. HDD is the bottleneck for performance at the moment and I'm looking into getting a new dedicated server but even with a new server, I still can't get the idea behind to write a humongous query just to query 10 products. I looked into "EXPLAIN" section of phpMyAdmin, most of this query is using non-indexed sections of the tables, that's why it is filling up slow_query.log on Mysql. This query runs on the homepage as well and it takes around 0.35 seconds on average to query only 10 products.
It's really not that crazy a query if you break it down. Effectively it is getting a listing of products based on your company_id for those products that are unique to your storefront and that are shared between storefronts..
How many products do you have? This query should take a second.
Do you have adequate memory on your server to support the high demands that cs-cart places on mySQL?
Do you have fast disks (SSD) so that indexes are read quickly?
Tony, you were right. I upgraded our server with 256GB SSD hard drives. It is much much better now.
Thanks
Glad it worked for you.
In cs-cart, Memory is your best friend with fast disk a close 2nd place.