Hello, Not sure if this question belongs here, let me know if it doesn't. It can also be answered here http://stackoverflow.com/questions/9808284/why-does-manually-implementing-a-hash-tag-give-a-performance-boost-to-my-queries and I'll cross post relevant info to stackoverflow if I receive it.
I have a Core Data app on iOS and what I noticed is that I get a significant performance boost when querying on hash tags (integers) as compared to when querying on strings, even though in both cases I use an index on the field. Is this expected behavior? Why doesn't sqlite implement a hash tag on strings itself when there is an index? I'm mainly asking because I think there might be something I am overlooking. Thanks, Kristof _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users