PromoErik Posted February 20, 2016 Share Posted February 20, 2016 Hello, I started fresh with a prestashop 1.6.0.14 install a few months ago and started to import products. At first I could import at product with maybe 180 combinations, however performance is becoming increasingly poor as I add more products. Now I'm down to maybe 70 combination, otherwise I get a server timeout error (5 min, host won't increase limit). Anyone having similar experiences? Anyone found a solution? Link to comment Share on other sites More sharing options...
bellini13 Posted February 20, 2016 Share Posted February 20, 2016 are you importing images at the same time, and also having thumbnails created? If so, do that as a separate step after the products are first imported Link to comment Share on other sites More sharing options...
PromoErik Posted February 20, 2016 Author Share Posted February 20, 2016 Hey Bellini, So I am doing a product import, just one product, then a combination import, just the combinations for that very product. Typically 180 combinations, and around 9 images. I don't have the options about thumbnails when doin imports but I am importing images (that are already on the server). But how come the performance has become worse? Any ideas? Link to comment Share on other sites More sharing options...
bellini13 Posted February 20, 2016 Share Posted February 20, 2016 I assume as the database size increases, inserts increasingly take longer as indexes have to be rebuilt. on some extremely large databases, they will drop all indexes when doing mass imports, and then re-create the indexes at the end. That avoids having to re-index after each insert. However it is usually overkill in a small ecommerce software like this. You are also on a shared hosting environment (I assume, since they restrict to a 5 minute timeout), so they could also be doing other things, like throttling your CPU. As for the images, I would separate them also. Get the products all imported, then do images afterwards. Make sure you do not generate thumbnails during the import. Once all the products are imported (which will be quicker without images and thumbnails), then you can always regenerate thumbnails later. Link to comment Share on other sites More sharing options...
newcomer Posted February 23, 2016 Share Posted February 23, 2016 How do turn off thumbnail generation during import csv? Link to comment Share on other sites More sharing options...
bellini13 Posted February 23, 2016 Share Posted February 23, 2016 It is an option you select during the import "No thumbnails regeneration" Link to comment Share on other sites More sharing options...
PromoErik Posted February 29, 2016 Author Share Posted February 29, 2016 Hey, Did some experimenting with my combination files. With images 117 rows, without 130, slight improvement but still pretty poor...any more ideas bellini? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now