How to reduce indexing time?For Catalog URL Rewrites
Que. How to reduce re-index processing time for Catalog URL Rewrites ?
Issue: catalog_url index take a more time when running indexing process.
We have analyzed and found there is need to check our database table core_url_rewrite related to url_rewrite data.
Following screen shots will clarify above statement.
08
Need to take some steps:

  • We need to remove unwanted entries of core_url_rewrite table.
  • Or we can disable/Off entry generation. Change configuration for generating Permanent Redirect urls, the Permanent Redirect urls are generated behalf of id_path.

Go to Magento Admin:
Open: System → Configuration → Catalog → Search Engine Optimizations →
Create Permanent Redirect for URLs if URL Key Changed – OFF
Check following screen shots.
09