PKP Bugzilla – Bug 6558
Optimize reviewer search by making interest joins conditional
Last modified: 2011-06-15 11:37:35 PDT
We are moving to Git Issues for bug tracking in future releases. During transition, content will be in both tools. If you'd like to file a new bug, please create an issue.
The reviewer search SQL includes joins into the controlled_vocab table which can be very slow. Make these joins conditional on whether the user is searching for interests.
Pushed to master and stable.
Needs backporting to OCS. See bug 6573.
Created attachment 3480 [details]
Patch against OJS pre-2.3.5
This may need some merging with the update in bug #6263