Fast reindex for Magento

Why is Magento’s URL re-index taking so long ?

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

We then noticed that Magento didn’t use some of the store’s and products’ settings.

• In fact, if you use short URLs for your products, Magento still creates both possibles URLs (long and short) in its index table.
Exemple :
for :
www.my-site.com/product.html
Magento also creates:
www.my-site.com/category/product.html

• If your product is disabled, hence is not visible on your store, Magento stills indexes its URL.
• If your product has several categories and sub-categories, there will be as many URLs as categories even if they aren’t used on your FrontEnd.
• Same for products that are « not visible individually » which are generally used as associated products to a configurable product.
  Their URL are created and stored in the database.

Устанавливаем и радуемся!
http://www.magentocommerce.com/magento-connect/dn-d-patch-index-url-1364.html