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, 2021

Hi, 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();

#1

BoldMinded (Brian)

Added to the next release. Thanks!

Login to reply