fancy, but extremely slow

[otzy]

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?

Edited December 29, 2014 by otzy (see edit history)

[tuk66]

For tens of thousands product, you need to focus on your database - cache, SSD and even optimize PrestaShop SQL queries (keys).