My catalog_product_flat indexing take too long time.

How to make this indexing faster in Magento 1.9

  • What is your hosting plan? Shared/Dedicated ? Oct 26 '18 at 10:04
  • deditcated hosting
    – sdfas
    Oct 26 '18 at 10:08
  • How many products, websites/ stores, attributes do you have? Oct 26 '18 at 21:05

You can't speed the process. Barring any errors on your site or any 3rd party modules that are affecting the speed of indexing, if you have thousands of items and hundreds of attributes that are getting indexed into the flat table, it's going to take time.

You can look into modules that provide asynchronous indexing like this one from mirasvit

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.