Scott, >> So it reads: grows from 3 MB to 85 MB. > That IS an important distinction!
So what to do? a.) let it grow. b.) do optimize() (but how often and how to detect when it is needed?) c.) create a new database by reindexing my data. (same problems as b.) d.) ignore the problem until complains come in and get nasty I tend to d.) -- Holger Lembke _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users