D. Richard Hipp wrote: >> Though if your db has reached a steady-state size you might consider >> running a VACUUM just *before* deleting the records, to avoid peaks >> persisting ... and even then (say) every *other* week. >> Just a thought ! >> > VACUUM also defragments a database file which sometimes helps > subsequent operations to run faster. >
Thanks Mike & Richard Your inputs are useful - the database won't grow that much and isn't really searched out of sequence much. It's mostly going to be used to just access things in sequence. But the inputs are useful towards other projects in the future!1 Cheers, Mohit. 10/28/2008 | 1:18 AM. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
