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:

  • catalog_product_attribute
  • catalog_product_price

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

  • What is the problem specifically? – Robbie Averill Jun 20 '15 at 5:20
  • something about "timeout exceeded" – Ryo Jun 20 '15 at 6:05
  • Please try increasing PHP Memory Limit of your server. – Rahul Kumar Das Jun 20 '15 at 6:49
  • Ok i will try that. So it mean i no need to use extra extension right ? Magento default can handle it. – Ryo Jun 20 '15 at 6:58
  • Max execution is probably more relevant @RahulKumarDas – Robbie Averill Jun 20 '15 at 11:26

We use the async index extension and it works. But you have to experiment with the config options to find the best way for you.

In addition the extension can not handle catalog url indexer for us. We do it on a different server. We have 200.000 SKUs.

BTW: I think Magento and more than 100.000 SKUs is always pain.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.