Our site (CE version 2.3.4) is extremely slow on the backend and frontend for a particular category which has over 100K items. What is the best way to split this up so that we can see performance improvements?
Right now when a customer clicks this category all the products in it are shown, 36 per page. We're currently doing all we can for ths smaller performance-enhancing tips a typical Magento 2 store owner would want to add.
Ideally we would like to split the large category up into 10 sub categories with 10k each but would this be possible? Wouldn't the parent category still have 100k products? I'm sure someone here has faced a similar issue?