I have a Woocommerce-powered site, with a product, that has 11 attributes. Each attribute can influence final product price, so I created all possible variations, the final number of them is several thousands... So now when I try to open product page, it is loading for about 2 mins.
Query Monitor shows that while forming attributes dropdown, Woocommerce queries every variation one-by-one, so at the end it makes 1591 queries of update_meta_cache and 1587 of WP_Post::get_instance().
Is there a possibility to make Woocommerce query them all at once? Or maybe another solution to product with many attributes/variations?
I googled extensively, but found no solution to such situation. I optimized everything I can in the website/database, switched themes, deactivated other plugins, but since the main culprit are those woocommerce queries, all my efforts decreased loading speed insignificantly.