Ticket #3851 (closed defect: fixed)

Opened 4 years ago

Last modified 4 years ago

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

Changed 4 years ago by tmb

  • status changed from new to closed
  • resolution set to fixed

Fixed in r5687 (before I finished writing the ticket! :-)

Note: See TracTickets for help on using tickets.