GitHub PushEvent at 2014-03-04 23:31:58
Repository: freesound
Actor: ffont
Payload: {"shas":[["de13373971ab352661989c9e182ceaf5a84757a3","1cf26b209f21ad8d01b7f07e3a8ceb894c6b820c@upf.edu","Add indexes to downloads table to make selects faster\n\nThe combination of a WHERE, ORDER BY, and LIMIT meant that we were\nordering entries first before filtering the relevant ones when showing\nlists of sounds, packs, and people. Instead, we create three new\ncomposite indexes:\n\nsounds_download(sound_id, created):\nFor people who downloaded a specific sound\n\nsounds_download(user_id, created)\nFor sounds downloaded by a specific user\n\nsounds_download(pack_id, created) WHERE pack_id IS NOT NULL\nFor packs downloaded by a specific user\nWe have a partial index where pack_id is not null because there are\nso many sounds in this table - we don't want to have to always\nskip over these rows","Alastair Porter",false],["4d984c7e811bcdb6148b2099e10e8ef88d093447","ef2016fd4f4a34d5160993e5bec3899cd32cb366@upf.edu","Merge branch 'speedups'","Frederic Font",false],["87c8347f42b7facf0cfd3390a439f03bd3ccebe4","ef2016fd4f4a34d5160993e5bec3899cd32cb366@upf.edu","#488 completed api authentication docummentation and fixed a bug regarding access token scopes","Frederic Font",false]],"size":3,"ref":"refs/heads/apiv2","head":"87c8347f42b7facf0cfd3390a439f03bd3ccebe4"}