Changing article reviewers is taking too long

Hello everyone,

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?

Regards

Renato L. Sousa

Hi @rensousa,

Please don’t double-post the same content – it clutters the forum. Someone will respond to your other post at Select reviewers taking too long. (If you think it’s been forgotten, feel free to reply to your existing post a week later as a reminder.)

Regards,
Alec Smecher
Public Knowledge Project Team

I’m sorry for that @asmecher,
I initially posted but forgot to select the question category. After that I tried to change the category or delete the post and could not.

Regards,