This project is mirrored from https://github.com/Ensembl/ensembl.git. Pull mirroring updated .
  1. 12 Nov, 2013 1 commit
    • Andy Yates's avatar
      [ENSCORESW-757]. Cannot perform a fast query on two OR fields from the same table. · 53b50cd1
      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).
      53b50cd1
  2. 21 Oct, 2013 1 commit
  3. 17 Oct, 2013 1 commit
  4. 30 Aug, 2013 1 commit
  5. 29 Aug, 2013 4 commits
  6. 22 Aug, 2013 3 commits
  7. 20 Aug, 2013 1 commit
  8. 19 Aug, 2013 4 commits
  9. 16 Aug, 2013 1 commit
  10. 15 Aug, 2013 3 commits
  11. 12 Aug, 2013 9 commits
  12. 09 Aug, 2013 3 commits
  13. 08 Aug, 2013 8 commits