Re: [sqlite] When to call VACUUM - revisited

2012-07-05 Thread Jay A. Kreibich
On Thu, Jul 05, 2012 at 01:29:18PM +0100, Simon Slavin scratched on the wall: > > On 5 Jul 2012, at 9:34am, _ph_ wrote: > > > I already read your previous replies, but to revisit my scenaro: > > > > - My OS is "sensitive to fragmentation" > > - We are running with

Re: [sqlite] When to call VACUUM - revisited

2012-07-05 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/07/12 05:29, Simon Slavin wrote: > Fragmentation of the database file on disk is something that SQLite > can't control, However you can ask SQLite to do things that will mitigate fragmentation by extending the file in larger blocks. See the

Re: [sqlite] When to call VACUUM - revisited

2012-07-05 Thread Simon Slavin
On 5 Jul 2012, at 9:34am, _ph_ wrote: > I already read your previous replies, but to revisit my scenaro: > > - My OS is "sensitive to fragmentation" > - We are running with auto-vacuum enabled, so the freelist_count is usually > small (not a good indicator) Ah. If

Re: [sqlite] When to call VACUUM - revisited

2012-07-05 Thread _ph_
Hi Simon, I already read your previous replies, but to revisit my scenaro: - My OS is "sensitive to fragmentation" - We are running with auto-vacuum enabled, so the freelist_count is usually small (not a good indicator) but fragmentation supposedly gets worse -We use sqlite as application

Re: [sqlite] When to call VACUUM - revisited

2012-07-04 Thread Simon Slavin
On 4 Jul 2012, at 10:54am, Hauptmann Peter wrote: > However, they also have rough indicators, whether or not it's necessary > (fragmentation or > a recommendation when closing Outlook) > > Q: Are there any useful indicators to suggest a VACUUM? >(Or, to reverse it:

Re: [sqlite] When to call VACUUM - revisited

2012-07-04 Thread Simon Slavin
On 4 Jul 2012, at 10:54 AM, Hauptmann Peter wrote: > However, VACUUM is by far requiring the most time, and with most uncertain > results > (i.e. whether or not it improves subsequent performance). VACUUM exists only to release unused space from the database file. If you

[sqlite] When to call VACUUM - revisited

2012-07-04 Thread Hauptmann Peter
Hi List, I've read what I could find about the issue, this thread: http://thread.gmane.org/gmane.comp.db.sqlite.general/57770/focus=57775  pretty much gathers the positions, ranging from  - don't  - don't worry  - don't expect to much  - let the user decide The last is closest to my approach -