Closed (fixed)
Project:
XML sitemap
Version:
7.x-2.x-dev
Component:
xmlsitemap
Priority:
Normal
Category:
Feature request
Assigned:
Unassigned
Reporter:
Created:
12 May 2008 at 22:09 UTC
Updated:
27 May 2008 at 17:51 UTC
There was recently an issue in the Pathauto queue related to speeding up queries on the url_alias table which I think might be able to help XML Sitemap as well. See http://drupal.org/node/212327
Basically instead of joining on src = concat('node/', nid)
You join on src = CAST(CONCAT('node/', nid) AS CHAR)
This took query times from 70 seconds to .27 seconds (in one test). So, it's pretty helpful. You have to do some trickery to get it to work on postgresql and there is a chance it only works with postgresql8.1+ but that should be pretty common anyway.
Comments
Comment #1
darren ohThanks for sharing, greggles. One thing to note: On PostgreSQL you must cast as VARCHAR to get a valid result. Works on any version of PostgreSQL.
Fixed in CVS commit 116103.
Comment #2
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.