Magento drops the index tables and then rebuilds them.
Meanwhile, clients dependent on those tables are out of service.
E.g., if the
catalog_product_flat index becomes invalidated or is in the process of rebuilding your frontend will almost entirely cease to function.
Why not rebuild table
When it's rebuilt, drop the old
catalog_product_flat_1 and rename the
With tens or hundreds of thousands of products it can take 10 minutes just to rebuild that one index. To reindex all tables it can take more than 30 minutes. Why not implement my idea?