[android-developers] Re: Slow searching in large sqlite database ?

[skink]

On Jun 30, 11:22 pm, sasq <jonas.minnb...@gmail.com> wrote:
> Without an index on the first column or using LIKE:  ~6500ms
>
> With index on first colum and GLOB: ~ 450ms
>

~15 times faster - quite good speed improvement, in my case it was
even ~80 times faster - i don't know why nob...@google.com really
tried to examine that phenomenon.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---