I would like to speed up a text search which currently uses two BLOB_TEXT Fields, "Class" and "Methods"
Code: Select all
while not(dm.tbl.EOF) do
if not(cbSearchMatchCase.Checked) then
MatchFound:=AnsiPos(SearchText,SearchData) > 0;
Can anyone point me at some code for using the SQLite FTS extension or something quicker than the above?
I found this but can't get it to work for way too many reasons to define here. I am sure it works as Žarko Gajić stuff is always spot-on, but just not working this installation.
http://zarko-gajic.iz.hr/full-text-txt- ... g-project/