On Tue, Feb 19, 2008 at 2:08 PM, Bryan Oakley <[EMAIL PROTECTED]> wrote: > 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.
Unfortunately, I have no answer for you (*). So this is an invitation for someone who knows better to answer :-). -scott (*) I'm primarily a Linux user, and primarily work w/in Google Gears, where fts is statically compiled. We're still using fts2 because in Gears VACUUM is compiled out entirely, so fts2 is safe. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
