-
Andy Yates authored
Our lookups of primary accessions and display labels with the Xref table was flawed. Seems MySQL can only use 1 index per query and it is not possible to create a single index that can handle querying on two columns when either could be our matching value. Solution is to break the query into two parts each targetting a single column. MySQL is a lot happier about this and query times have dropped from 30 seconds on USEast to 18ms (9ms per query).
f6aa1756