I have a new site that currently has 12000 nodes on it. I made a mistake in in one of the alias paths and had to regenerate just the alias for content type. This took 19 hours to complete.

My site is a search engine type site that aggregates data from the web and programatically saves it to the database, so it won't be uncommon for 5000 to 25000 entries per week to need aliasing.

There are only about 50 users a day on the site. Site has 4 GB ram, VPS linux box, apc, memcache.

Is there a way to approach these updates differently when I have to do them so this takes less time (an hour, tops). Maybe do it programatically somehow?

the site is http://www.buyagainbaby.com

Thanks

Comments

bago’s picture

bago CreditAttribution: bago commented

Are you on MySql 5.0 ? If so, can you test the patch in here: http://drupal.org/node/1415930 ?