All Sqlite Expert, I have one table, I am inserting and deleting record to and from this table very 250ms. I always maintain 1000 rows in this table. I have another table, I am inserting and deleting data to and from this table every 1s. The data record in this table maintains at 200,000 rows. Can I get some recommendation on what is optimized technique to do the vaccum for my database?
Thank you, Liang _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users