If you’re experiencing a slow Magento admin interface try either or both of the following.
Using Magento 1.5ish you may find the following line
Mage::getModel('catalogrule/rule')->applyAllRulesToProduct($productId);
in “/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php”.
Comment it out. You should see a tremendous improvement.
Secondly, you may change the indexing update mode.
- Log in to admin area.
- Go to the “Index Management” page through “System => Index Management”.
- Select indexes you want to change. If you’re unsure, select all.
- “Change Index Mode” from the “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 faster. You may no longer have a performance problem.
// CrashMAG
You could also check that NAT reflection is enabled in your router - that did the trick for me.
Part of the problem can be solved by the extension Catalog Database Accelerator http://magepro.org/extentions/catalog-database-accelerator.html in case if saving the products in the backend takes you too much time. The system needs to make re-indexing of the entire site each time you change the catalog and it makes to work Magento backend extremely slow. With this module a user does not have to manually index the site, to sit and wait - the system itself does the re-indexing in the background mode.