Thanks for your reply. I have done some quick timing tests on my system; a vacuum can take 5 or more minutes (synchronous full), and a delete and recreate is rougly 3 seconds. I think I did such a test with a 30MB database. The database resides on a jffs2 file system (compression off), which seems to have a constant time for deletions.
I should have included I am using sqlite 3.4.0. On Sun, May 18, 2008 at 4:45 AM, <[EMAIL PROTECTED]> wrote: >> Hi I have a general design question. I have the following senario... > > IMHO your design sound reasonable. In relation with the vacuum question > I suggest try to delete and re-create each table and watch both timings. > > HTH > > Adolfo > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users