My sqlite database has about 82,000 entries in it and I want to be able to dynamically load suggestions quickly using android's AutoCompleteTextView. I've tried increasing the threshold, but there is still a noticeable delay between entering text and the AutoCompleteTextView updating the suggestions list dynamically. What steps can I take to optimize this process?
Asked
Active
Viewed 310 times
0
-
1Some code could be useful... – Bogdan Zurac Jan 27 '13 at 10:36
-
1I agree with @Andrew, some code or maybe the SQL you use to select on the table will be helpful, also, a table of `82,000` entries may be too big in sqlite if you have to query on the table frequently. – neevek Jan 27 '13 at 10:54
-
Is your database properly indexed? – Clyde Jan 28 '13 at 05:20