Re: [sqlite] Vacuum on sqlite file fills the .wal file and it never shriks since

2011-11-09 Thread Yuriy Kaminskiy
Richard Hipp wrote: > On Tue, Nov 8, 2011 at 10:04 AM, Orit Alul wrote: > >> Hi, >> >> I've performed a vacuuming operation (I ran the following command: >> sqlite3.exe VACUUM;). >> It caused the WAL file to be the same size as the db file and it never >> shrink back. >> >> For example I had a d

Re: [sqlite] Vacuum on sqlite file fills the .wal file and it never shriks since

2011-11-09 Thread Richard Hipp
On Tue, Nov 8, 2011 at 10:04 AM, Orit Alul wrote: > Hi, > > I've performed a vacuuming operation (I ran the following command: > sqlite3.exe VACUUM;). > It caused the WAL file to be the same size as the db file and it never > shrink back. > > For example I had a db file in the size of 1.8GB, wal

[sqlite] Vacuum on sqlite file fills the .wal file and it never shriks since

2011-11-09 Thread Orit Alul
Hi, I've performed a vacuuming operation (I ran the following command: sqlite3.exe VACUUM;). It caused the WAL file to be the same size as the db file and it never shrink back. For example I had a db file in the size of 1.8GB, wal file in the size of 1.7MB, shm file in the size of 32KB. I ran