Ticket #3851 (closed defect: fixed)
Browse by author - list pages very slow in 3.2
|Reported by:||tmb||Owned by:|
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