{"shas":[["29fe36522d8c4e567426a6cda4d16c7c631cf707","985d11a6abeef2b01fe673c343f5ebd7ae5cb198@gmail.com","Add TV metadata patch for libav 0.7","Anthony Doko"],["dbe22c2c0298585ee3f5fcbbccacfe9d18eba0f5","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","libav 0.7: use avformat_open_input() instead of av_open_input_file()","Julien BLACHE"],["bb8f9de8ec1a848f311e926bbd13fab094510e71","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","libav 0.7: use avformat_write_header() instead of av_write_header()","Julien BLACHE"],["ed20d3f7de65dded6bcf322a812726f067ee73bd","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","libav 0.7: use av_get_bytes_per_sample() instead of av_get_bits_per_sample_fmt()","Julien BLACHE"],["a2f409dd0a61c9b8f1cc027d7f0c02083e3a2a1e","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","libav 0.7: use av_dump_format() instead of dump_format()","Julien BLACHE"],["0b2df545249c2809c00fca2a31536f046ee7f5c8","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","libav 0.7: switch to generic AVDictionary for metadata handling","Julien BLACHE"],["3caae459be85bf358b4183979c8bb09a82c5fcdd","cda6ac5737093c6f8e29ff7fdf7ce1a2f740dadc@fastmail.co.uk","Add DB maintenance routines","Peter Carmichael"],["1909623d43f73da02391289969384ec376c94969","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Run ANALYZE after DB startup","Julien BLACHE"],["6e10252021b5a06a61c3fa2b3794cc7b6e59c111","cda6ac5737093c6f8e29ff7fdf7ce1a2f740dadc@fastmail.co.uk","Perform post-bulk-scan DB maintenance","Peter Carmichael"],["181b1e772f0126d2d652caca83ce93f2371ba520","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Add a logdomain for DB performance data","Julien BLACHE"],["a2b7b811b839b89f2e24f747366d272683853f5a","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Add query plan to DB profiling callback","Julien BLACHE"],["d05634fddd7c0983bba14ae135a4b6800f3a4d1e","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Print query execution time in milliseconds","Julien BLACHE"],["333b7710bc3ead707005cbed388766297f71f4c8","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Queries must hit SQLITE_DONE to execute profiling callback","Julien BLACHE"],["96c367f556625e0124e6a4729d7f704ab8ea81c6","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Kill useless database indexes","Julien BLACHE"],["1dfd27090e0572e8b69c0ce13a598647f3c9e9e3","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Speedup startup rescan","Julien BLACHE"],["becdfdb06229f8c3c3a280102c10868fe8b6b26d","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Add new indexes for general speedup\n\nAn index on songalbumid helps for joins on songalbumid on the files table; a\ncovering index on disabled+media_kind+songalbumid helps in numerous queries\nall over the place.","Julien BLACHE"],["617c02606031246685a918488a42b601d211dd9b","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Add covering indexes for *{,_sort} fields\n\nThese indexes help queries searching on these fields and will act as covering\nindexes for sort strings, too.","Julien BLACHE"],["cbc7108fcfc8541c9fe07b6800fd23c03d4377c6","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Use table aliases in all queries, update RSP & DAAP filters to match","Julien BLACHE"],["664067fd888dc2c2dfe5f663705500d41dab1171","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Rewrite group queries, remove JOIN, add index\n\nSQLite has trouble optimizing the query when written with JOIN, but does\npretty well using the indexes when written without JOIN. Add an index for\nthe query, too.","Julien BLACHE"],["efcd463946edf739420b9708658db552fa2bf735","7b85a41a628204b76aba4326273a3ccc74bd009a@jblache.org","Add indexes for playlists","Julien BLACHE"]],"ref":"refs/heads/master","size":26,"head":"e7bc751884ddc3d8a96bd8e02ede050c25d4cacc","push_id":42428039}