Ticket #3851 (closed defect: fixed)
Browse by author - list pages very slow in 3.2
| Reported by: | tmb | Owned by: | |
|---|---|---|---|
| Priority: | Priority Fix | Milestone: | 3.2.4 |
| Component: | DB | Version: | 3.2 |
| Severity: | normal | Keywords: | |
| Cc: |
Description
List pages (/view/creators/foo.html) very slow in 3.2.
MySQL slow query log lists:
SELECT DISTINCT M.creators_name_family, M.creators_name_lineage, M.creators_name_given, M.creators_name_honourific FROM eprint_creators_name M;
Runs OK in 3.1 database.
=> wierd problem with distinct/empty utf8 columns?
tdb fix: change order of fields (as used in SQL query) in MetaField::Name @PARTS to family given lineage honourific
Change History
Note: See
TracTickets for help on using
tickets.
