Skip to content
  • Dan McGee's avatar
    Use sane ORDER BY clauses in package list queries · 3c110b13
    Dan McGee authored
    
    
    We were doing some silly things here with an "ORDER BY Name, CategoryID"
    clause, due to the fact that Name is unique, and thus any additional
    ordering after Name will have no effect. Of course, the dumb as a box of
    rocks MySQL query optimizer doesn't realize this, leading to full table
    scans every time of ~30000 packages instead of using index scans for the
    ordering and only retrieving the first 50 rows.
    
    The biggest change is noted in the default sort order as it cuts down
    the columns to one, but we can remove the redundant sort from other
    orderings as well, even though those will still not be able to use an
    index-driven query plan.
    
    Signed-off-by: default avatarDan McGee <dan@archlinux.org>
    Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
    3c110b13