Magento Forum

   
Page 2 of 2
[SOLVED] dramatic performance issues with product->save()
 
Rabee3
Jr. Member
 
Avatar
Total Posts:  9
Joined:  2010-05-21
Amman
 

I am had the same problem , and i tried the solution of turning off the cache , which did work for every 40 - 50 products , then started to get slower again.

So my added tweak on the solution , is to make a shell script to execute the PHP script for a number of time you need for every 50 products for example , this way you can save products faster than running the PHP Script for all the products.

Tested on 15000 products.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Rabee3
Jr. Member
 
Avatar
Total Posts:  9
Joined:  2010-05-21
Amman
 

I had the same problem , and i tried the solution of turning off the cache , which did work for every 40 - 50 products , then started to get slower again.

So my added tweak on the solution , is to make a shell script to execute the PHP script for a number of time you need for every 50 products for example , this way you can save products faster than running the PHP Script for all the products.

Tested on 15000 products.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lmsweb
Jr. Member
 
Total Posts:  26
Joined:  2008-12-11
 

Can you explain this a little further?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mirasvit
Guru
 
Avatar
Total Posts:  638
Joined:  2009-08-22
 

When a large number of goods or attributes need to be saved, backend works very slow, as each time you save data the system re-indexes the goods through the entire catalog.

Asynchronous Reindexing is a solution of solve this problem. When a product or category is saved it is not immediately re-indexed, but put into a queue. The queue is re-indexed in the background. This greatly speeds up the backend. This mechanism is implemented by using an extension of http://mirasvit.com/magento-extensions/magento-asynchronous-reindex.html.

 
Magento Community Magento Community
Magento Community
Magento Community
 
d rock
Jr. Member
 
Total Posts:  10
Joined:  2010-06-30
 

I found the secret sauce when performing bulk product operations (anything with tons of product->load() calls in a loop) was to call

$product->clearInstance()

This helps to avoid growing memory problems when the PHP garbage collector hasn\\\’t been run yet.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 2 of 2