On Jun 30, 2:36 pm, skink <[email protected]> wrote:
> On Jun 30, 2:24 pm, sasq <[email protected]> wrote:
>
> > 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
>
> wild guess: you use select expr1 and expr2 syntax?
>
> maybe: select expr from select expr2?
I use AND yes - I don't understand your alternative syntax.... maybe a
small example?
(I also noticed that it only goes fast for certain phrases - almost
like it doesn't to a binary seek, just uses the index to find the
starting position for a linear search).
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
