On Tue, Sep 16, 2008 at 12:02 AM, Holger Lembke <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: >> Database will grow from about 3.615 KB and continue growing. >> After 100 more FILLs (40.000 delete+insert actions.) it >> reaches a size of 85.683 KB. > > Just in case we are confused due to European and American dots: those are > European dots. > > So it reads: grows from 3 MB to 85 MB.
That IS an important distinction! In the 3MB range, optimize() is probably still pretty reasonable. It's basically a sorted merge, so the time required will be dominated by I/O cost. If your database is not fragmented, it can be pretty fast, but for databases with lots of updates over long periods, this kind of thing can start to slow down a lot. -scott _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
