Posted on May 28, 2020 by jamie

Install: https://www.dnd.fr/2012/09/magento-patch-how-to-optimize-re-index-processing-time-for-url-rewrite/

TRUNCATE catalog_url_rewrites;

• In your BackEnd, go to : > System > Configuration > Developer
  
• If you can’t see the extension, purge the Magento Cache and sessions, log out and log in to your Back End.
  
• Select YES on the field Enable Optimisation
• If you don’t need to generate URLs for disabled products or not visible individually products, select YES for the 2 other fields.
  
• Save
  
• Go to the Index Management and re-index only your URLs.