Android 號碼查詢性能優化

我的需求是做一個快速撥號界面！list列表顯示所有聯系人Calllog資料！原來的做法在前面的日志中有提到！大概是先查

1. Cursor phoneCursor = this.managedQuery(
2. ContactsContract.CommonDataKinds.Phone.CONTENT_URI, null, null,
3. null, null);

1. Cursor phoneCursor = this.managedQuery(
2. ContactsContract.CommonDataKinds.Phone.CONTENT_URI, null, null,
3. null, null);

再根據號碼來查聯系人

1. if(0 < phoneCursor.getCount()){
2. phoneCursor.moveToFirst();
4. // find all contact list
5. while (phoneCursor.getPosition() != phoneCursor.getCount()) {
6. ContactEntity contactentity = new ContactEntity();
7. contactentity.contact_id = phoneCursor
8. .getLong(phoneCursor
9. .getColumnIndex(ContactsContract.CommonDataKinds.Phone.CONTACT_ID));
10. contactentity.contacts_phone_type = phoneCursor
11. .getInt(phoneCursor
12. .getColumnIndex(ContactsContract.CommonDataKinds.Phone.TYPE));
13. contactentity.contacts_phone_number = phoneCursor
14. .getString(phoneCursor
15. .getColumnIndex(ContactsContract.CommonDataKinds.Phone.NUMBER)).replace(
16. "-", "");
18. contactCursor = this.managedQuery(
19. ContactsContract.Contacts.CONTENT_URI, null,
20. ContactsContract.Contacts._ID + "="
21. + contactentity.contact_id, null, null);
22. contactCursor.moveToFirst();
23. contactentity.contacts_display_name = contactCursor
24. .getString(contactCursor
25. .getColumnIndex(ContactsContract.Contacts.DISPLAY_NAME)).replace(
26. "-", "");
29. Uri uri = ContentUris.withAppendedId(ContactsContract.Contacts.CONTENT_URI,
30. contactentity.contact_id);
31. InputStream input = ContactsContract.Contacts.openContactPhotoInputStream(getContentResolver(), uri);
32. if(null != input){
33. contactentity.contact_phone_bmp = BitmapFactory.decodeStream(input);
34. }
36. // spell name can
37. contactentity.spellName = PinYin.getInstance(this).getPinyinString(
38. contactentity.contacts_display_name);
40. Log.i(TAG, "contactentity.contact_id: " + contactentity.contact_id
41. + " contactentity.contacts_phone_type: "
42. + contactentity.contacts_phone_type
43. + " contactentity.contacts_phone_number: "
44. + contactentity.contacts_phone_number
45. + "contactentity.contacts_display_name: "
46. + contactentity.contacts_display_name
47. + "contactentity.contact_phone_bmp: "
48. + contactentity.contact_phone_bmp);
49. phoneCursor.moveToNext();
51. customArrayList.add(contactentity);
52. }

1. if(0 < phoneCursor.getCount()){
2. phoneCursor.moveToFirst();
4. // find all contact list
5. while (phoneCursor.getPosition() != phoneCursor.getCount()) {
6. ContactEntity contactentity = new ContactEntity();
7. contactentity.contact_id = phoneCursor
8. .getLong(phoneCursor
9. .getColumnIndex(ContactsContract.CommonDataKinds.Phone.CONTACT_ID));
10. contactentity.contacts_phone_type = phoneCursor
11. .getInt(phoneCursor
12. .getColumnIndex(ContactsContract.CommonDataKinds.Phone.TYPE));
13. contactentity.contacts_phone_number = phoneCursor
14. .getString(phoneCursor
15. .getColumnIndex(ContactsContract.CommonDataKinds.Phone.NUMBER)).replace(
16. "-", "");
18. contactCursor = this.managedQuery(
19. ContactsContract.Contacts.CONTENT_URI, null,
20. ContactsContract.Contacts._ID + "="
21. + contactentity.contact_id, null, null);
22. contactCursor.moveToFirst();
23. contactentity.contacts_display_name = contactCursor
24. .getString(contactCursor
25. .getColumnIndex(ContactsContract.Contacts.DISPLAY_NAME)).replace(
26. "-", "");
29. Uri uri = ContentUris.withAppendedId(ContactsContract.Contacts.CONTENT_URI,
30. contactentity.contact_id);
31. InputStream input = ContactsContract.Contacts.openContactPhotoInputStream(getContentResolver(), uri);
32. if(null != input){
33. contactentity.contact_phone_bmp = BitmapFactory.decodeStream(input);
34. }
36. // spell name can
37. contactentity.spellName = PinYin.getInstance(this).getPinyinString(
38. contactentity.contacts_display_name);
40. Log.i(TAG, "contactentity.contact_id: " + contactentity.contact_id
41. + " contactentity.contacts_phone_type: "
42. + contactentity.contacts_phone_type
43. + " contactentity.contacts_phone_number: "
44. + contactentity.contacts_phone_number
45. + "contactentity.contacts_display_name: "
46. + contactentity.contacts_display_name
47. + "contactentity.contact_phone_bmp: "
48. + contactentity.contact_phone_bmp);
49. phoneCursor.moveToNext();
51. customArrayList.add(contactentity);
52. }

經過測試發現性能消耗主要在這個while循環當中！因為在循環當中在加一個查詢數據庫操作自然慢！