I am using Magento 1.9.x and hosted on AWS server. In my store, there are 26 website and stores are available.

Problem: If I create a product without selecting a website and stores then it is saving product very fast but If I add the product in multiple websites then it is taking more than 1 min to save each product.

I have checked the core code and print the log and got 128 SQL queries are executing for one store. So if I select more stores while creating the product it is adding 128*number queries. As I understand this is the reason to take time for saving a product. I need as less time as we can use.

1 Answer 1


You can try the below solution, The below solution is for enterprise multi store cluster configuration, but it will work with the community too,

Please check the mysql configuration.


Hope this help.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.