I'm having EXTREME performance Issues with 1.5 at the moment, I think it's largely due to having a many products within the store I'm setting up, but none of these issues were present in the old version that was being run.
Currently I have 17500 products, with 400 categories.
As it stands, I can't use SEO because of the time it's taking to load - on average it's taking about 10seconds to load each page. I managed to figure out it was because of the amount of categories that exist. If I were to disable all the categories the page load time would be minute. This is obviously something we must have enabled, but as it stand I can't...
My second problem is down to the search function - as soon as you search for something it's just bringing the whole site down to a halt for 10mins or so, for me and everyone else. Its just completely unuseable! Once again I've managed to find the cause of it to be the DB query
Code: Select all
SELECT COUNT(*) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (LCASE(pd.name) LIKE '%cat%' OR p.product_id IN (SELECT pt.product_id FROM product_tag pt WHERE pt.language_id = '1' AND pt.tag LIKE '%cat%'))
The two things alone are just so bad I'ts making this store unuseable... SEO is a must and a store without a seach facility is rather bad! I have just read a post by Daniel about 1.5 being better at handling large amounts of data but so far it seems 1000x worse.
Both these problems where not present in the old 1.9.4 version, it's actually running quite nicely even with the amount of products / categories... But we really would like 1.5 running.