My magento website installed multi-warehouse extension. The concept of this extension is generating all product separate for each warehouse. and this make my db is very big. so far I check my database more than 500,000 product sku generated.
Problem is when I reindex, it alway error even I use SSH command. these 2 table I got a problem when reindex:
I already upgrade server to cloud but it may not enough. I found this extension: https://mirasvit.com/magento-extensions/magento-asynchronous-reindex.html
but not sure it work or not. Anyone who had experience on this extension and try with huge database pls recommend.
Thank so much