This is a super, super slow query. It happens when the caches are cleared. Is it strictly necessary? Can we speed it up somehow?

713.521ms

xmlsitemap_link_count

SELECT COUNT(xsm.loc) FROM xmlsitemap xsm INNER JOIN system s ON s.name = xsm.module WHERE s.type = 'module' AND s.status = 1 AND xsm.changefreq <> 0 AND xsm.changed <> 0 AND (xsm.priority >= 0 AND xsm.priority <= 1)

Comments

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

You could try using the 6.x-2.0 version of the module which is being developed for performance and scalability in mind.

chrism2671’s picture

chrism2671 commented

On a scale of 1 to 10, how would you rate it for stability?

hass’s picture

hass commented

1000 :-)

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Closed (won't fix)