Maximum number of products presta can handle? [urgent]

[Destiny84]

Last night, I ran an import with roughly 250.000 products. The import finished successfully, but ever since, the prestashop mysql queries have been eating up all the server's capacities, and the account has been banned about an hour ago (the import finished some 10 hours ago...), as it was slowing down the rest of the websites on the server.

Does anyone know whether prestashop can handle these large amounts of products? Is there anything that I can do to speed up presta in order to get the account un-banned, other than deleting all the products from the database?

Thanks a lot in advance !!

[razaro]

Not sure about maximum number of products but see following topics maybe it could help you .

http://www.prestashop.com/forums/viewthread/66014/configuring___using_prestashop/quarter_of_a_million_products

http://www.prestashop.com/forums/viewthread/45000/development/slow_database_queries_identifying_and_fixing_dot_

[Destiny84]

Thank you for these links. I tried some of the workarounds ,and also managed to identify some other slow queries , but presta kept being slow (faster than before, but not really user- or serverfriendly). I ended up deleting all of the newly imported products from the database...

[tomerg3]

One of the parts that is slow is to do with new products, do you have the new products module enabled?

Also, how many categories did you create?

[Destiny84]

Yes, the new products module is enabled, but I tried the changed version of Product.php which was in the other topic.
And I had all of the products in one large category. It was not really meant for browsing, but mainly for customers to be searchable (contains mainly spare parts). So it would be advisable to divide the products into multiple subcategories of the containing category? Which is a suitable size of products per category then?

Also, this is prestashop 1.2.5, are there any performance upgrade for 1.3?

Thanks for the help, love Prestashop so far, but this is giving me a headache....

[tomerg3]

I'm not about performance upgrades in 1.3, but the search modification I posted is only for 1.2.5 and it's a huge boost.

Try to disable the new products module, and also tags, that should allow you to have the products in one category