What DB Tables are Altered During Reindexing? 

Please LogIn to Reply!

Post By: admin | 26-01-2012 06:35 Reply

 

Hello all, I’m running a Magento CE 1.5.0.1 installation with a current catalog size is ~ 1.5 million products. It currently takes 9 hours for us to reindex. As the catalog continues to grow, it will become impossible to take our network of stores down for the length of time reindexing takes.

I was wondering if anyone knew, definitively, what DB tables are altered/affected by the reindexing process. My thought is that we can reindex on our dev or staging server, then simply import the DB tables affected by reindexing from dev or staging to production when we’re ready to go live with our changes. In theory, this would allow us to completely avoid ever having to reindex directly on production.

Thoughts?

`Reply Or Comment!
Please LogIn to Reply!