Agence DnD

Dn'D Patch Index URL

  • Popularity Score 3611 Popularity Score

    Popularity ScoreReferrals to Site/Downloads

    0 0 1+ 1+ 250+ 250+ 1000+ 1000+ 10000+ 10000+

How to optimize re-index processing time for Url Rewrite ?
Compatible with:
This extension is currently unavailable on Magento Connect. Please contact the developer.

You will be re-directed to the developer's website to complete your purchase.

You must be registered and logged in to get extension key.
In order to get this extension, you must be logged in to the Magento Community. Click here to login or register.

Magento Connect 2.0

Magento Connect 2.0

FREE
Previous Next
Overview

Dn'D Patch Index URL

The index optimization extension we developed allows a better control over the URLs that need to be generated (or not) and therefore improve the duration of the process.

For example :

With 9500 references (SKU), shared (or not) between 900 categories / Sub-categories and with CMS pages, the number of generated URLs in the «Core_URL_Rewrite» table is about 80 000.

The re-index (launched manually or by CRON) lasts about 3h30.

After this patch deployed, the re-index duration is about 1 minute!

Full article & Benchmark available @ http://www.dnd.fr/2012/09/magento-patch-how-to-optimize-re-index-processing-time-for-url-rewrite/

M1 Extension Versions

1st version

2012-10-31 17:56:41
  • Version number: 1.0.0.0
  • Stability: Stable
  • Compatibility: 1.5, 1.6, 1.6.1, 1.6.2.0, 1.7
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

1st Version
Q&A
(3 Questions : 0 Answers)

Product Q&A

Ask your questions. Share your answers.

 
 
« Back
 
 
Sort by
 
0 answers

Internal server error

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26951526
Customer avatar
Getting internal server when running url reindex after installing the extension ?
Any ideas ?
by
cmcarparts
-
3 years, 1 month ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_27252406
Customer avatar
by
mwaters4
-
2 years, 11 months ago
0points
1out of 2found this question helpful.
Was this helpful?Yes1No1
 
0 answers

Ready for 1.9.2.1?

Avatar Image Url:: https://www.magentocommerce.com/magento-connect/skin/frontend/enterprise/connect/images/pictures/developer-avatar.jpg
Customer avatar
Does this extension work for 1.9.2.1?
by
mainbird
-
4 months, 4 weeks ago
-1point
0out of 1found this question helpful.
Was this helpful?Yes0No1
  • 2017-01-17 T09:28:58.568-06:00
  • bvseo_lps, prod_bvqa, vn_prr_5.6
  • cp-1, bvpage1
  • co_hasquestions
  • loc_en_US, sid_15074, prod, sort_default
1 of 1
  • 2017-01-17 T09:28:58.569-06:00
  • bvseo_lps, prod_bvqa, vn_prr_5.6
  • cp-1, bvpage1
  • co_hasquestions
  • loc_en_US, sid_15074, prod, sort_default
1 of 1
Get Help

Support for This Extension

The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Magento Platform Support

If you need support for a Magento platform, there are different options for support depending on which Magento platform you are using. Below are links for specific platforms.

Reviews

About the Developer

This extension was developed by and is supported by Agence DnD

Rated 4.6 out of 5 by 28 reviewers.
Rated 2 out of 5 by I find this solution kinda useless… The free patch is almost of no use. If 'exclude disabled product = yes’, then, if I enable a product, it won’t appear. Re-index is quick, but not quality. I got a different problem, too many records in the table. In short, some might find this patch suitable, but I found a better solution on Magentoconnect. November 10, 2016
Rated 5 out of 5 by Thank you for the patch. Its really work We have on website ~90,000 products and in url_rewrite table it was 556853 records. Right after we installed the patch and clear url table, after finish reindex we have only 27794, but all product urls are working fine. Enabled and visible we have something like 5,000 products. Url Reindex took after patch ~1-2mins. And its really great! Thank you, guys! June 14, 2016
Rated 5 out of 5 by Works great! I have a catalog of 27,000 products & about 30 categories. When reindexing it was taking about 1 hour 10 minutes on average to index. I just installed this, truncated core_url_rewrite table, cleared cache and ran the url rewrite index and it took 3 minutes 08 secs. I cannot believe it! Works like a charm. Thank you. Also, just a note this was on 1.9.2.3. Before: https://www.dropbox.com/s/1kulqlt5vq3qcmw/Screenshot%202016-02-19%2011.15.51.png?dl=0 After installing module: https://www.dropbox.com/s/cmvfqoxgblhovy3/Screenshot%202016-02-19%2011.13.38.png?dl=0 February 19, 2016
Rated 5 out of 5 by Too good to be true but true! Really awesome! Saved a lot of space in my core_url_rewrite table and it does re-index fast! Thank you so much for sharing this for free! Used it with Magento 1.9.2.2 December 5, 2015
Rated 5 out of 5 by 24 hour url indexing now takes 24 minutes! Pure magic! Thanks a ton to the devs for providing this extension for free. Working awesome on our store with 100k products and 4 stores. October 17, 2015
Rated 5 out of 5 by AWESOME!!! This is the greatest performance optimization extension I have ever used. We have suffered by slow backend and re-indexing processes. After installing this extension, total number of URL rewrites reduced down to 18k from 220k. Huge improvement! It works perfectly on 1.9.0.1 May 27, 2015
Rated 5 out of 5 by Good module I tried this extension on CE 1.7 and on 1.9.1.0. On 1.7 it did wonders with the indexation time, but on 1.9 it doesn't make such great timings. Here is my comparison made on CE 1.9.1.0, on a store with ~160.000 SKUs: Magento default indexation results: Product Attributes index was rebuilt successfully in 00:02:21 Product Prices index was rebuilt successfully in 00:05:09 Catalog URL Rewrites index was rebuilt successfully in 00:33:22 Product Flat Data index was rebuilt successfully in 00:20:00 Category Flat Data index was rebuilt successfully in 00:00:11 Category Products index was rebuilt successfully in 00:04:01 Catalog Search Index index was rebuilt successfully in 00:58:06 Stock Status index was rebuilt successfully in 00:00:00 Tag Aggregation Data index was rebuilt successfully in 00:00:01 Using Dn'D Patch Index URL: Product Attributes index was rebuilt successfully in 00:02:28 Product Prices index was rebuilt successfully in 00:06:21 Catalog URL Rewrites index was rebuilt successfully in 00:13:01 Product Flat Data index was rebuilt successfully in 00:20:05 Category Flat Data index was rebuilt successfully in 00:00:08 Category Products index was rebuilt successfully in 00:03:51 Catalog Search Index index was rebuilt successfully in 00:57:42 Stock Status index was rebuilt successfully in 00:00:00 Tag Aggregation Data index was rebuilt successfully in 00:00:00 As you can see, it saves me only 20 minutes on URL Rewrites, on the other indexes it's almost the same as the default index. Anyway it's a good module for inferior versions of Magento, big thumbs up for this extension guys. thanks! February 15, 2015
Rated 5 out of 5 by You saved my day! This extension works excellent with CE 1.9.1.0! Great Job! January 28, 2015
Rated 5 out of 5 by A must have Perfect extension, it works like a charm. it took me less than a minute instead of >45min to reindex all urls. January 26, 2015
Rated 5 out of 5 by Works on 1.9.1 Works just as discribed. For those that can not get this to work on versions later than 1.7 - Then prior to installation disable cache and compliation, after installation flush your magento cache, and storage cache and enable cache processes, then run compilation, log out and back in. You will find at config/developer/Index Url Optimisation set all three to Yes! January 2, 2015
  • 2017-01-17 T09:29:04.314-06:00
  • bvseo_lps, prod_bvrr, vn_prr_5.6
  • cp-1, bvpage1
  • co_hasreviews, tv_28, tr_28
  • loc_en_US, sid_15074, prod, sort_default
2 3 next>>

In order to upload extension, you must be logged in to the Magento Community. Click here to login or register.

Close

Register

* Required Fields

Close window

Forgot Your Password?

Please enter your email below and we'll send you a new password.

* Required Fields

Close window

Login

To upload extension you must be logged in.

* Required Fields

Close window

You are using an outdated browser

We built Magento Connect using the latest techniques and technologies.
This makes Magento Connect faster and easier to use.
Unfortunately, your browser doesn't support those technologies.
Use the links below to download a new browser or upgrade your existing browser.