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?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
