Scott, Thanks for the "full table scan hints", I'll change my design.
> You're seeing two effects. I set up a small test. Its a bunch of windows shell scripts (good old dos stuff). http://www.lembke.eu/fts3.zip For security reasons the sqlite3.exe is missing. Run CREATE than FILL. Repeat FILL. Database will grow from about 3.615 KB and continue growing. After 100 more FILLs (40.000 delete+insert actions.) it reaches a size of 85.683 KB. With your "optimize" trick I start with 5.032 KB ("optimize" grows the database from 3.615 KB to 5.032 KB) and end at 6.740 KB after the 100 more FILLs and an optimize after each FILL. Thats very OK for me. :-) Thanks for the long answer, I think the WIKI page http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex should contain the "optimize" trick. -- Holger Lembke _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
