Re: [sqlite] auto_vacuum default setting

2013-08-29 Thread _ph_
auto_vacuum at full is slower: When you delete some data, SQLite would shrink the file size to the minimum. If, in the next transaction, you add new data, SQLite would again have to extend the file size by at least a page. This takes time. Without auto-vacuum=FULL, the Insert statement would

Re: [sqlite] auto_vacuum default setting

2013-08-29 Thread Stephen Chrzanowski
Ahhh.. Thats the difference. Auto_Vacuum versus Vacuum pragmas. doh. Shoulda thought of that. I blame 2am. On Thu, Aug 29, 2013 at 5:43 AM, Clemens Ladisch wrote: > Stephen Chrzanowski wrote: > > On Thu, Aug 29, 2013 at 3:03 AM, Clemens Ladisch >

Re: [sqlite] auto_vacuum default setting

2013-08-29 Thread Simon Slavin
On 29 Aug 2013, at 9:16am, techi eth wrote: > Here I am looking what is best strategy sqlite3 provide for database > purging.What combination of auto vacuum & vacuum to be used? > > I have started using sqlite from few weeks so answer from experience will > help me. If you

Re: [sqlite] auto_vacuum default setting

2013-08-29 Thread Clemens Ladisch
Stephen Chrzanowski wrote: > On Thu, Aug 29, 2013 at 3:03 AM, Clemens Ladisch wrote: >> 3. auto_vacuum will increase fragmentation > > I thought it did a complete dump to a new file? says: | Auto-vacuum does not

Re: [sqlite] auto_vacuum default setting

2013-08-29 Thread Stephen Chrzanowski
How on #3? I thought it did a complete dump to a new file? On Thu, Aug 29, 2013 at 3:03 AM, Clemens Ladisch wrote: > techi eth wrote: > > When I look through details about PRAGMA auto_vacuum,I think it is always > > beneficial to have auto_vaccum set to Full so that

Re: [sqlite] auto_vacuum default setting

2013-08-29 Thread Clemens Ladisch
techi eth wrote: > When I look through details about PRAGMA auto_vacuum,I think it is always > beneficial to have auto_vaccum set to Full so that whenever delete happens we > have shrink of size. > > I wanted to know is their any benefit to have this to none in default > instead of full. 1.

[sqlite] auto_vacuum default setting

2013-08-29 Thread techi eth
When I look through details about PRAGMA auto_vacuum,I think it is always beneficial to have auto_vaccum set to Full so that whenever delete happens we have shrink of size. http://www.sqlite.org/pragma.html#pragma_auto_vacuum I wanted to know is their any benefit to have this to none in default