| commit | 72c4b2612a06636343e2803c0c84fdfbd5ba2f63 | [log] [tgz] |
|---|---|---|
| author | Daniel Lehmann <lehmannd@google.com> | Mon Nov 14 16:22:17 2011 -0800 |
| committer | Daniel Lehmann <lehmannd@google.com> | Mon Nov 14 16:22:17 2011 -0800 |
| tree | 894a29e223b3a00585fac0eaf9bd1d4532644055 | |
| parent | b5000cb82b8abd301e6e7b3b3f6d71e219b56f1c [diff] |
Optimize STREQUENT queries and fix estimated table row counts - Use id instead of strings for matching mimetypes - Use inner LIMIT of 25 to prevent the extra subquery (also fixes correctness) - Reorder JOIN for data-usage-stat JOIN contacts - Defeat sqlite3's "optimization" attempt by using +0 on fields from contacts/data <-- This is huge Bug:5560534 Change-Id: I412d359afe07f32643cc2faef8735b719686741f