Hi, I've performed a vacuuming operation (I ran the following command: sqlite3.exe <dbName> 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 the VACUUM; command on the db file, now the db file got down to 1.2GB, wal file got up to 1.2GB and the shm file got up to 9.5MB. Do you have a clue what is the cause for this strange behavior? Do you know if there's a command that can shrink the files back? Thanks, Orit [Creative Zone by MediaMind]<http://feeds.mediamind.com/CreativeZone> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
