I just tested GLOB and noticed the same things as you. I did a search on two columns without limit that yealds around 12 rows results.
Without an index on the first column or using LIKE: ~6500ms With index on first colum and GLOB: ~ 450ms Strange like you said, but thanks - this is surely fast enough for me :) On Jun 30, 11:41 pm, skink <[email protected]> wrote: > sasq, > > i just reread my prevoius thread about LIKE and it seems that you have > to use GLOB instead > > see link i posted in previous post --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
