Agence DnD

Dn'D Patch Index URL

  • Popularity Score 1252 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.
In order to get this extension, you must have active Magento Go Store. Click here to create Go store.

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/

Release Notes

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
Reviews

About the Developer

This extension was developed by and is supported by Agence DnD

Dn'D Patch Index URL 4.5 5 18 18
Awesome Extension! Must have! Extension does what it has to do. My personal thanks to the developers. August 28, 2013
Genius!!! This is genius! This fixes a huge flaw in the bloated magento platform. The core_url_rewrite process needs to be as quick as possible since it actually blocks orders from going through. This should be a default option in the magento product. Bravo! July 21, 2013
You'll need this once your store hits 100.000+ products I was faced with a store that features 1.2 mio. unique skus and the number was growing each day by 10 to 50k. The catalog_url index wasn't working anymore and we couldn't throw more ressources at the MySQL server, it was already maxed out. The only solution was reducing the amount of URLs the catalog_url indexer created and this extension kept its promise. I haven't rolled it out to the production server yet but on a identical development server with a reduced catalog size the table core_url_rewrite went from about 50k rows down to 25k while the whole process took a little less than a minute. Of course, your milage may vary depending on your server hardware and the settings in the backend. This particular store only has one store view and no need for the category url to be included in the product urls. March 15, 2013
Page permission issue I'm trying to download the extension, however the link/key is not working. Forbidden You don't have permission to access /community/Dnd_Patchind*****/ on this server. Please check and provide alternative link to download the extension. Thanks February 28, 2013
I can confirm that the speed increase is excellent on version 1.7. Prior to installing this the default url rewrite index would time out with 1.2million SKUs. This plugin completed rewrites in 90 minutes. I would like to run this also on my version 1.5 site and although I can install it without an issue there is no option showing up to enable it. November 22, 2012
Very impressed. I had ~166000 rows in url_rewrite table, ran this and it went up to 170000+. Then I emptied core_url_rewrite in mysql and ran reindex. Now on ~6625 rows which is about right. There have to be performance benefits for not having mysql search such a monster table. Thanks a lot! November 1, 2012
I've tested on low machine and work perfectly! Great Work November 1, 2012
Perfect for x-large multi stores, saved and will continue to save serious time in the future. Works great on CE 1.7.0.2, Thank you for this free extension, great job! October 31, 2012
<<prev2
Q&A
(2 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
-
9 months 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
-
7 months ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0
1 of 1
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.

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.