Hello, Here's another newbie question, but it doesn't look like the documentation for vacuum covers this.
I'm using SQLite to store an application's log. Suppose I have a program that runs nightly and deletes log records that are older than 60 days, to keep the database from growing without boundaries. I understand that deleting the records doesn't shrink the database file, unless I also vacuum. However, will SQLite re-use the space taken by the deleted records to store new ones? (Would I be better off not doing vacuum, and letting SQLite reuse the disk space instead?) I believe this is the case with PostgreSQL. Thanks, glauber _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users