CODEWITHSUNDEEP
mysqldrupalquery-optimizationpathauto
Konstantin Pereiaslov
Konstantin Pereiaslov

Reputation: 1824

How to speed-up path lookup for large number of nodes?

After I generated 34000 url aliases for all the nodes on Drupal 6 site, using pathauto, the site started to work really slow, every page loads more than 2 seconds. I'd really want my site to be search-engines-friendly, so it would be much better if every node had it's own URL, based on its title. Is there any way to speed up drupal page alias lookup? I tried creating indexes for all fields on table url_alias, but it doesn't help.

Upvotes: 1

Views: 499

Answers (1)

Sergey Litvinenko
Sergey Litvinenko

Reputation: 593

You need to use Pressflow or this patch http://drupal.org/node/456824

Upvotes: 2

Related Questions