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
