I have a need of creating more than 5000 stores in a month. How many stores can we create in Magento 1.9? Is there any limit?
Magento have no technical limit to create stores, but you have the problem, that magento creates a price index which is based on:
- customer groups
So when you create only store views, you don't get a problem here. If you create websites, your index will explode when you only have a few products because:
# websites * # customer groups * # products * # tax classes
The biggest problem I experianced for such a big number of store views are product attributes and related to this the product import.
Rule 1 for so many storeviews: disable the category and product flat tables. Maybe only in system cobfig is not enough, I saw some actions trigger the index even if it is not used, so maybe you need to rewrite some classes and make method calls empty.
If you have a lot of product attributes, you maybe want to maintain them over a seperate table to improve speed of import actions to a acceptable level. Especially if you have a lot of attributes who are the same between storeviews, as you can build an improved lookup logic.
For search you want to use an external solution like solr or elastic search anyway.
Maybe even disable to include the category path in product url, else you have a lot of additional entries there.
Another point, have a person who is complete dedicated to configure your mysql setup. Use the most current mysql (5.6), use ssd and no virtualisation for mysql.
And think about why you have so many storeviews and think about how you maybe could cheat to reduce them(often they are used because of translations)
In the end, you can use Magento for this many storeviews, but a lot of features are not usable like initialy intended
Also I wrote a while ago about such issues, not the final truth, maybe some parts wrong, but hope it helps anyway.