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

502 views Asked by At

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.

1

There are 1 answers

0
Sergey Litvinenko On BEST ANSWER

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