| commit | a65c5443d17d497703272b7ae2f0aa5b165bff3f | [log] [tgz] |
|---|---|---|
| author | Marco Nelissen <marcone@google.com> | Fri Apr 24 08:17:51 2009 -0700 |
| committer | Marco Nelissen <marcone@google.com> | Thu Apr 30 10:44:12 2009 -0700 |
| tree | 3ce86aa6c2107cfd210a79fce248dd1713286384 | |
| parent | 20157b15638a08aa376e8ad35d14f8be5d20562a [diff] |
Improve performance and memory usage of the big media search union query. Memory usage is reduced by encouraging sqlite to use an index when traversing the audio table, which means it doesn't need to do a separate sorting pass, so it no longer runs out of memory on very large datasets. It's also about 35% faster on my sample large dataset.