Hi,
I am no expert but try to increase your btree page size to the default page
size of your storage. I think sqlite defaults to a 1K page size but im sure
you can bump it up to 4K and see if that helps. I work with rather large
databases ( 5-8Gb ) and although increasing my page size from 1K to
Hi,
I am running into some issues that seem related to the current database
file size.
I think it has to do with the file system cache: if you
database is small, the entire database is held in your
systems file cache. Once the database exceeds a certain
size, real disk operations have to be
on analyzing
the right combination of page size and cache size.
-Abhitesh.
-Original Message-
From: Michael Scharf [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 11, 2007 1:23 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] File size issue?
Hi,
I am running into some issues
What is worse is that VACUUM didn't really help that much. It takes
forever, and it doesn't really fix the fragmentation either.
That used to be the case, but VACUUM is vastly improved in the latest
version of SQLite.
