sasq wrote: > I have a large(ish) database - around 30MB, created offline with > 400,000 rows. > Doing a simple select (name LIKE pattern%) and then showing the query > in a listview takes about 10 seconds. I tried indexing that field but > no difference.
LIKE usually involves a table scan, which will take a long time. > If this is normal I will just use a raw data file and do a binary > search myself. Or, find a way to avoid the LIKE, such as holding a separate indexed column for the prefix. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://twitter.com/commonsguy Android App Developer Books: http://commonsware.com/books.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
