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 6061 - Optimize AuthorDAO::getAuthorsAlphabetizedByJournal
Optimize AuthorDAO::getAuthorsAlphabetizedByJournal
Status: NEW
Product: OJS
Classification: Unclassified
Component: General
PC Linux
: P5 enhancement
Assigned To: PKP Support
Depends on:
  Show dependency treegraph
Reported: 2010-10-20 11:58 PDT by Alec Smecher
Modified: 2012-06-06 15:53 PDT (History)
1 user (show)

See Also:
Version Reported In:
Also Affects:

Patch against OJS 2.3.3 (906 bytes, patch)
2010-10-20 12:17 PDT, Alec Smecher
Details | Diff
Additional patch against OJS 2.3.3 (1.32 KB, patch)
2010-10-28 09:58 PDT, Alec Smecher
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Alec Smecher 2010-10-20 11:58:50 PDT
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>.)
Comment 1 Alec Smecher 2010-10-20 12:17:58 PDT
Created attachment 3288 [details]
Patch against OJS 2.3.3

The attached patch should provide a couple of very minor optimizations.
Comment 2 Alec Smecher 2010-10-20 12:18:22 PDT
(Note: Attachment #3288 [details] has not yet been committed. Waiting for feedback.)
Comment 3 Alec Smecher 2010-10-28 09:58:00 PDT
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.