Thanks. Yes, it seems that putting everything in a rawQuery() sped things up a lot - but only when I just searched on the indexed column.
If I involve a second column - even though the first condition limits the result set to just 20-30 rows - it takes over 10 seconds again, meaning it will be much faster to just search on the indexed column and then use java code to sort out the other criteria. Is it simply that sqlite sucks - at least on Android ? -- Sasq On Jun 30, 1:34 pm, skink <[email protected]> wrote: > Mark, > > On Jun 30, 12:26 pm, Mark Murphy <[email protected]> wrote: > > > LIKE usually involves a table scan, which will take a long time. > > not exactly, see my prev post. i already addresed that issue but got > no answer from anyone. i think it has something to do with underlying > sqlite though. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
