I am working on a Magento shopping cart and testing data import and export procedures. The export works fine. I change a few items and import the file back into the system. I can check the products tab and see all the modifications show up. I placed modifications on both the first and last row as well as intermediate ones. It does run slow. My ultimate question is related to the indicator for number of records processed. It won't stop and it tell me 0% processed. I am running ver 1.3.0 I noticed in other posts that this was a concern. Any feedback would be appreciated since the client won't be able to dig into the php database to see if it finished each time.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: fiboPosted on 2009-09-18 at 23:41:01ID: 25371759
Somewhere in the import parameters is defined the "bucket size", the number of rows in a csv file managed at a time.
By default this is is 1 and generates a very slow import.
Change this figure to something between 10 and 100... and your import speed will improve quite a lot.
Why not put 1000 or more? because all these records are kept in memory and if your objects are complex this would eat quite a lot of RAM and, in fact, crash your import.
My suggestion:
- just now, place 20, run your import so that everybody sees it is manageable
- increase RAM to the max available / allowed - 256 to 512 Megabytes seem common, the more the better (you might need to decide if this maxram is used for Magento as a whole -it would be great and speed up all your processes-, or if this maxram is just for imports) [you can change maxram magentowide with htaccess or php.ini]
- since imports will happen regularly, eg for prices or quantities on stock updates, do some experimentation to find a correct size for this import to happen as fast as possible without crashing.