Implemented Combining Queries

[bart]

Wouldn't it be a good thing to (find a way to) combine these queries? I quess there will be more once you have more addons installed.

SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('page_nav', 'resource_index', 'nat_childlinks') AND style_id = ? AND language_id = ?
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('resources_tab_links', 'nat_linkstemplate', 'PAGE_CONTAINER') AND style_id = ? AND language_id = ?
 
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('arcade_copyright') AND style_id = ? AND language_id = ?

 

[Mike]

The add-ons simply need to pre-load the templates. They can do this when a template is created, for example, based on the template being created.

 

[bart]

Ah thanks. I saw "resource" in the query and immediately presumed it was the new RM. It wasn't . Excuse me.

 

[xf_phantom]

resources_tab_links is from the RM

 

[Mike]

It's the structure of another add-on (or 2) that causes it to be pulled in a separate query though.

 

[bart]

Both Nodes as tabs as the Arcade add the extra query.