Bug 6558 - Optimize reviewer search by making interest joins conditional
Optimize reviewer search by making interest joins conditional
Status: RESOLVED FIXED
Product: OJS
Classification: Unclassified
Component: Reviewers
2.3.5
All All
: P3 normal
Assigned To: PKP Support
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-03-30 12:46 PDT by Matthew Crider
Modified: 2011-06-15 11:37 PDT (History)
1 user (show)

See Also:
Version Reported In:
Also Affects:


Attachments
Patch against OJS pre-2.3.5 (6.93 KB, patch)
2011-04-11 16:40 PDT, Matthew Crider
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Matthew Crider 2011-03-30 12:46:46 PDT
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.
Comment 2 Matthew Crider 2011-04-11 16:40:19 PDT
Created attachment 3480 [details]
Patch against OJS pre-2.3.5
Comment 3 Mike Kamermans 2011-06-15 11:37:35 PDT
This may need some merging with the update in bug #6263