Clemens, Fine, thank you. We thought we had misunderstood and we were right, we had!
We are just checking the COLLATE NOCASE option on the RAG table and re-running the tests again as the improvement was so dramatic we don?t believe it :) Rob. > On 3 Jul 2015, at 09:26, Clemens Ladisch <clemens at ladisch.de> wrote: > > Rob Willett wrote: >>> Do you ever depend on any indexing on the "Text" column which is not >>> COLLATE NOCASE ASC ? If not, then you should be able to speed up your >>> search by defining the column the way you think of it. So in your table >>> definition use >>> >>> "Text" TEXT COLLATE NOCASE ASC, >> >> We don?t think adding ASC is allowable > > Indeed it isn't; ASC makes sense only for (sorting) an index. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users