PKP Bugzilla – Bug 6061
Last modified: 2012-06-06 15:53:47 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.
Optimize AuthorDAO::getAuthorsAlphabetizedByJournal; it appears to be a slow query. (See <http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=6711&p=25904#p25904>.)
Created attachment 3288 [details]
Patch against OJS 2.3.3
The attached patch should provide a couple of very minor optimizations.
(Note: Attachment #3288 [details] has not yet been committed. Waiting for feedback.)
Created attachment 3311 [details]
Additional patch against OJS 2.3.3
The attached patch improves performance by avoiding TEXT columns in the temporary table for the query, moving to explicit GROUP BY instead of SELECT DISTINCT.