RSS Feed/News Template title search is slow on large installations

[ENXF NET]

Template title search unnecessarily joins full template records for entries that do not match.

Suggested fix: Filter by xf_template_map.title before joining the matching templates.

Code:

SELECT `xf_template_map`.*, `xf_template_Template_1`.*, `xf_addon_AddOn_2`.*
FROM `xf_template_map`
INNER JOIN `xf_template` AS `xf_template_Template_1` ON (`xf_template_Template_1`.`template_id` = `xf_template_map`.`template_id`)
LEFT JOIN `xf_addon` AS `xf_addon_AddOn_2` ON (`xf_addon_AddOn_2`.`addon_id`...

Read more

Continue reading...