[OJS 2.4.8-2] freezes when selecting Reviewers

Hi Jason,

No problems. Your answers have helped me a lot in finding a solution to the problem.

I suspect there are some problems with the tables as they have been mismanaged for a long time, with no security or control concerns to prevent spammer accounts.

I noticed that all OJS tables (in my database are 170 :thinking::thinking::thinking:) have storage engine like MyISAM instead of InnoDB.

In the tests I did, changing the engine decreased response time from 2 min 32 sec to 34 sec !!!

See the number of table records involved in these SQL statements:

  • review_assignments: 6469
  • users: 5569
  • roles: 7502
  • articles: 2879

I’m sure there are a lot of unnecessary records, but removing them without affecting real records is a huge challenge.

Regards,

Renato L. Sousa