CODEWITHSUNDEEP
databasemagento
s4lfish
s4lfish

Reputation: 633

Magento Database CleanUp

After deleting several StoreViews in order to increase the database performance in several tables are entries of old StoreViews i.e. in catalog_product_index_eav are ~4mio. old entries left with store_ids which doesn't exist any more.

Some background information: We had ~450k products and 21 StoreViews ... way too much. Therefore we splitted the installations and now 400k products and 1 StoreView is left ... but also millions of old entries. It seems Magento doesn't clean delete StoreViews or websites with all unneeded indexes.

Is there any "good" way to clean up the complete database?

Upvotes: 0

Views: 552

Answers (1)

Afroz Alam
Afroz Alam

Reputation: 874

After deleting store views delete files fron var/locks and then reindex. Hope all related entries shall be deleted.

Upvotes: 2

Related Questions