On Fri, May 13, 2016 at 8:29 AM, Yihong Zhan <yhzhan at cadence.com> wrote:
> Hi sqlite experts, > > I am using sqlite back up API of the latest sqlite version. I find an > issue that the target database seems not shrink when the source shrinks. > ... > Is it a bug, a known issue? I believe the size of the target database > should be kept consistent with the source database. Otherwise, quite lots > of disk space will be wasted in case source database shrinks Not a bug: sqlite saves removed "pages" for later use. Use the VACUUM command to tell it to get rid of them and shrink your file. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
