On Feb 19, 2008 3:59 PM, Scott Hess <[EMAIL PROTECTED]> wrote: > On Tue, Feb 19, 2008 at 1:49 PM, Bryan Oakley <[EMAIL PROTECTED]> wrote: > > Also, I've seen references to fts3 -- is there a compelling reason for > > me to switch to fts3 from fts2? > > fts2 has a design flaw which can cause corruption of the fts2 index if > you run VACUUM against the database. If you never run VACUUM, you'll > be fine. fts3 is mostly identical to fts2, with this flaw fixed.
Is fts3 built-in to sqlite? I don't build my own -- I use the tcl bindings and just download a binary. I'm too stingy to buy a microsoft compiler :-\ I'm on 3.5.0 now, if I upgrade to 3.5.6 will that be included in the tclsqlite3.dll? I don't quite recall how I got my hands on the fts2.dll I have on disk. Thanks for the quick response! _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
