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.