I have a complicated problem with ojs-2.4.8-5.
When admin tries to select a reviewer for an article (link http://my-site.com/index.php/site/editor/selectReviewer/[article_code] ) the system takes about 2 minutes to display the reviewers.
I changed all tables to innodb, which reduced the response from 5 minutes to 2 minutes, but it’s still time consuming.
After analyzing the SQL sentences involved in this operation, I found that there are 2 sentences that consume this response time. They are complex sentences with several inner join.
What can I do to improve this response time?
Does your installation take all that?
Renato L. Sousa