I'm setting to to delete a bunch of old records ever 2 weeks in a cron job and initially I just wanted to do delete * from table where datetime(created_on, 'localtime') < some_date.
Then, I remembered about vacuum - do I need to vacuum the database whenever I delete the records? Should I just 'exec' the statement by setting the sql to "delete .... something ... ; vacuum;" and execute that? Is that the recommended approach? Thanks, Mohit. 10/27/2008 | 11:16 AM. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
