diff options
| author | Vasu Nori <vnori@google.com> | 2010-10-19 09:53:12 -0700 |
|---|---|---|
| committer | Android Git Automerger <android-git-automerger@android.com> | 2010-10-19 09:53:12 -0700 |
| commit | d0ab3293cc2f3c252b0c1f7e6db7d08dcfe15f3c (patch) | |
| tree | 8c3027c9980e7cd57c0ee21fab4cc9e3a73f68b6 | |
| parent | 994c32a995a85937faf59e37a9fc88b526470d7d (diff) | |
| parent | 09562b6c3a420ded0d02b9bd2290de2dbab9e304 (diff) | |
| download | packages_providers_ContactsProvider-d0ab3293cc2f3c252b0c1f7e6db7d08dcfe15f3c.zip packages_providers_ContactsProvider-d0ab3293cc2f3c252b0c1f7e6db7d08dcfe15f3c.tar.gz packages_providers_ContactsProvider-d0ab3293cc2f3c252b0c1f7e6db7d08dcfe15f3c.tar.bz2 | |
am 09562b6c: bug:3097939 trigger on a table without good index = slow contacts app
Merge commit '09562b6c3a420ded0d02b9bd2290de2dbab9e304'
* commit '09562b6c3a420ded0d02b9bd2290de2dbab9e304':
bug:3097939 trigger on a table without good index = slow contacts app
| -rw-r--r-- | src/com/android/providers/contacts/ContactsDatabaseHelper.java | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/com/android/providers/contacts/ContactsDatabaseHelper.java b/src/com/android/providers/contacts/ContactsDatabaseHelper.java index f58136a..c92f743 100644 --- a/src/com/android/providers/contacts/ContactsDatabaseHelper.java +++ b/src/com/android/providers/contacts/ContactsDatabaseHelper.java @@ -576,6 +576,8 @@ import java.util.Locale; db.execSQL("CREATE INDEX IF NOT EXISTS " + DATABASE_PRESENCE + ".presenceIndex" + " ON " + Tables.PRESENCE + " (" + PresenceColumns.RAW_CONTACT_ID + ");"); + db.execSQL("CREATE INDEX IF NOT EXISTS " + DATABASE_PRESENCE + ".presenceIndex2" + " ON " + + Tables.PRESENCE + " (" + PresenceColumns.CONTACT_ID + ");"); db.execSQL("CREATE TABLE IF NOT EXISTS " + DATABASE_PRESENCE + "." + Tables.AGGREGATED_PRESENCE + " ("+ |