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

Reply via email to