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.

Bug 8153 - Rewrite submission queue PHP into SQL
Rewrite submission queue PHP into SQL
Status: RESOLVED FIXED
Product: OJS
Classification: Unclassified
Component: General
3.0b
All All
: P3 normal
Assigned To: PKP Support
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-03-11 10:24 PDT by Alec Smecher
Modified: 2013-06-28 13:06 PDT (History)
1 user (show)

See Also:
Version Reported In:
Also Affects:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alec Smecher 2013-03-11 10:24:24 PDT
Currently the OMP/OJS3.0 submission queues (unassigned and assigned, potentially also "my submissions") iterate through all submissions in PHP and pick out the desired subset. This will be too costly for all but the smallest production journals; this logic will need to be rewritten into an SQL query.
Comment 1 Jason Nugent 2013-06-27 07:33:02 PDT
use paging on grids, move logic into SQL for submission queue where possible
https://github.com/pkp/pkp-lib/commit/5576b224593c2bde4ffc9087c1ae3302e8d50143
Comment 2 Jason Nugent 2013-06-27 07:45:01 PDT
move submission queue logic into SQL where possible
https://github.com/pkp/omp/commit/c31bf0c45f9a13c817af6bf04b36635e53f895cc
Comment 3 Jason Nugent 2013-06-28 11:09:44 PDT
Closing for now.  Testing will show whether further optimizations are needed.
Comment 4 Alec Smecher 2013-06-28 11:35:04 PDT
Great! Thanks, Jason -- and it looks OTOH like this covers OJS master as well?
Comment 5 Jason Nugent 2013-06-28 13:06:33 PDT
Yes, these commits went into both OMP and OJS master.