the original magento indexing happened to be so slow , in my case I had millions of SKUs need to be indexed , converted to flat table & url rewritten .

original magento indexing takes to many days & then it stop

after digging in the code I saw its very complicated task and usually it delete all the catalog_product_flat table causing the site to go offline

any suggestion to have custom indexer , faster indexer ???

Magento Version : CE

thanks for suggestion

the original magento indexing happened to be so slow , in my case I had millions of SKUs need to be indexed , converted to flat table & url rewritten .

I am not talking about search indexing .

original magento indexing takes to many days & then it stop

after digging in the code I saw its very complicated task and usually it delete all the catalog_product_flat table causing the site to go offline

any suggestion to have custom indexer , faster indexer ???

Magento Version : CE

thanks for suggestion

to be clear :

I am importing my product using custom api , but these product need to be indexed ( in magento way ) to be added to url rewrite table , converted to flat .. etc , these are magento specific tasks and they are so slow

the original magento indexing happened to be so slow , in my case I had millions of SKUs need to be indexed , converted to flat table & url rewritten .

original magento indexing takes to many days & then it stop

after digging in the code I saw its very complicated task and usually it delete all the catalog_product_flat table causing the site to go offline

any suggestion to have custom indexer , faster indexer ???

thanks for suggestion

the original magento indexing happened to be so slow , in my case I had millions of SKUs need to be indexed , converted to flat table & url rewritten .

original magento indexing takes to many days & then it stop

after digging in the code I saw its very complicated task and usually it delete all the catalog_product_flat table causing the site to go offline

any suggestion to have custom indexer , faster indexer ???

Magento Version : CE

thanks for suggestion