Hi, (Hello all, new user... refreshing my rusty sql knowledge)
I have a simple table created with create virtual table ft using fts3(id, content); and store id/text-pairs with delete from ft where (id="theid"); insert into ft values ("theid", "sometext"); To test the table I have 400 files containing old mails. Just an random choice of contents. Ids are internally counted up simply, so it is 1 to 400. I remove ":" and cr/lf from mails but leave everything else. But the effect seems to be content independant. If I repeat this process multiple times I get a growing database. select count(*) from ft and ft_content stays at 400, ft_segdir stays at 30. But select count(*) from ft_segments is raising, from 756, 1237 to 2100 and so on. Ok, that explains the growing of my database file. What is wrong? Thanks! -- Holger Lembke _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users