We found an excessive loading of data from the database when generating the main page of a journal issue
OJS 3.3.0-14
pages\issue\IssueHandler.inc.php:322
$sections = Application::get()->getSectionDao()->getByIssueId($issue->getId());
In addition to information about sections, data about articles is loaded here, which is not required for this page.
We have replaced this line
$sections = [];
foreach ($issueSubmissions as $vis) {
$secid=$vis->getCurrentPublication()->getData(‘sectionId’);
if(!array_key_exists($secid, $sections))
$sections[$secid] = Application::get()->getSectionDao()->getById($secid);
}
In our case, we managed to get an increase in speed by 1.5 - 2 times