3 Jun
2010
3 Jun
'10
9:20 p.m.
On 03/06/2010 19:17, William Blunn wrote:
If you are going to keep the SQLite database around, you might want to look at vacuuming it periodically using either VACUUM or the auto_vacuum PRAGMA depending on what fits your context best.
http://sqlite.org/lang_vacuum.html http://sqlite.org/pragma.html#pragma_auto_vacuum
Actually pragma auto_vacuum is probably not going to be right here because it may cause fragmentation.
Bill