On 29 Sep 2011, at 2:30pm, Mr. Puneet Kishor wrote: > Well, defeated by FTS4 for now, I will try the following approach -- > > 1. drop the fts tables and rebuild them and test. > > 2. if the above doesn't work, then either migrate the data to Postgres and > use its fts, or implement e-Swish or httpdig for full text search.
You know, given that SELECT, you may just not need FTS4. If you have decent indexes it should only need to search a few thousand records for the search string and you can do that with LIKE. The entire search should take less than five seconds, probably less than one second. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users