PKP Bugzilla – Bug 8153
Rewrite submission queue PHP into SQL
Last modified: 2013-06-28 13:06:33 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.
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.
use paging on grids, move logic into SQL for submission queue where possible
move submission queue logic into SQL where possible
Closing for now. Testing will show whether further optimizations are needed.
Great! Thanks, Jason -- and it looks OTOH like this covers OJS master as well?
Yes, these commits went into both OMP and OJS master.