Publisher does not support the Fluid field type. Please do not contact asking when support will be available.
If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.
Ticket: Improved query speed
Status | Resolved |
Add-on / Version | Publisher 3.2.3 |
Severity | |
EE Version | 5.4 |
Studioweb
Mar 06, 2021Hi, changing this query in publiser/Service/TemplateTranslation.php saved almost 1 second in load time
fetchTemplatesOrganizedByGroup()
$qry = ee(‘db’)->select(’*’)->from(‘template_groups AS g’)
->join(‘templates AS t’, ‘g.group_id = t.group_id’)
->where(‘g.site_id’, $this->request->getSiteId())
->get();
$qry = ee(‘db’)->select(‘g.group_name, t.template_id, t.template_name’)->from(‘template_groups AS g’)
->join(‘templates AS t’, ‘g.group_id = t.group_id’)
->where(‘g.site_id’, $this->request->getSiteId())
->get();
BoldMinded (Brian)
Added to the next release. Thanks!