Scott, > If you're worried about things at the level of kilobytes, > then you may be outside the core target for fts. optimize() > should work reasonably well for that size of dataset.
I don't know if and about what I'm worried. I just noticed it and then thought about my poor users, that do use the software all day long with perhaps 1000 del/add actions per day and end with a 1 gb database file and wonder what is going on... And if they wonder I know what they will do to me. And I only saw it growing, the growth not documented and /me wondering, where it all would end. But main concern was that I did something wrong and had an error in my code. Case closed for me. Thanks! -- Holger Lembke _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users