It seems that with each new version Prestashop gets slower and slower.
1.6 is unfortunately not an exception.
I need to manage tens of thousands products in a single category. I understand, that traditional pagination will not work, but even the first page in category takes sometimes 15 seconds to load.
Prestashop is the one of the best solutions - simple, user friendly and with a rich set of features.
But looking at code I see that approach remained the same as it was in the version 1.3 or even earlier.
Just have a loook at SQL in Product->getNewProducts(). Stuffing sql with all data just leads to full table scan.
Another example is ProductSale->getBestSalesLight() with it's IN clause, built dynamically as a string from all product ids. Can you imagine the size of resulting string?
Layered navigation block - executes individual query for every product in the category. Must be disabled if you want your site had signs of life
Category->getProducts() - full table scan and ambigious fields the recordset.
I'm pretty sure this is a not complete list of issues.
Why I'm writing about this here? I'm a fan of Prestashop since version 1.3, but now I'm thinking about migrating to another platform.
I see that Prestashop team does a great job. But may be it's a time now to cleanup the code instead of racing for features?