I have few configurable products with huge number of variations. They have almost 5k children simple products assigned to them on average.
While loading the files both on admin and frontend, it takes long time. Any kind of save / update operations are same way consumes a lot of time. I had to increase memory limit and time out in my server configuration to prevent errors.
Is there any way to optimize the handling the large configurable products? Because theoretically Magento doesn’t have any limit of children products for a single configurable product.
If a configurable product with 5000 associated products makes the system slow, a product with more than 20k or 30k child products would crash the system.
EDIT:
Found an open issues related to this. I have already my indexers set to schedule.