A few specs: Using magento 2.1 PHP 7.0.9 VPS has 48GB RAM 8x Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz
I am setting up an online print shop, and have created a CSV of all of our 100k+ variations we offer. Our latest variation range is the leaflets, offering these on 6 different papers, 13+ sizes, 5+ lamination methods, 4+ delivery speeds, 20+ quantities. Some delivery speeds are not available on certain quantities etc, ad we end up with about 11k associated products on this 1 configurable product. Last night it all loaded fine, tried a bunch of the options, prices updated correctly etc. However this morning I tried it, and the page wouldnt even load. Upon logging into WHM and checking the CPU usage, alot of CPU was being used on 1 process.
11250 (Trace) (Kill) str 0 65.33 0.38 /opt/cpanel/ea-php70/root/usr/bin/php-cgi
Anyone know a way of trying to find out what could be causing it? Is it the fact Magento cant handle 11k associated products?