dbikash wrote: > However, the delete command "DELETE FROM table WHERE time < XXX" is very > slow (XXX is in time_t format). VACUUM is even slower. (I need to VACUUM > since I have a restriction on the database size.) My database has 1 million > records and is more than 100 MB in size. > Bikash, I was recently advised that there is no need to do a VACUUM since SQLite will reuse the pages as it goes along. So, I stopped from doing that.
Do you have an index on your time field? Cheers, Mohit. 11/7/2008 | 5:46 PM. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
