In default Magento installation, admin area is particularly slow. The reason for this is that admin area can’t use much cache and more database operations. After adding products it becomes even slower. Modifying or adding a new products becomes very slow.
To over this and improve admin area performance we can disable automatic updating of indexes. With default settings, when adding or modifying products, Magento have to update multiple indexes. These indexes may include “Product Attributes” index, “products prices” index and few others.
To avoid this, we can change the index update mode to manual. This will not update indexes automatically at time of modifying products, so the changes may not reflect on frontend. After modifying products admin will have to update these indexes manually.
Here is how you can change index update mode
- Login to admin area
- Go to “Index Management” page through “System > Index Management”
- Select indexes you want to change. If you are not sure which one to select than select all.
- Select “Change Index Mode” from “actions” drop down. Selecting this will show another dropdown “Index Mode”.
- Select “Manual Update” from “Index Mode” dropdown.
- Click “Submit” button.
You will see message like “Total of X index(es) have changed index mode.”
This should make adding and modifying products significantly fast. Be careful that you update these indexes after modifying the products other wise your changes will not reflect on front end. Updating these indexes can be done from same page that is “Admin > System > Index Management” page.