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
-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
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
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
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:
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
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 -
7 matches
Mail list logo