RE: [sqlite] File size issue?

> 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.

RE: [sqlite] File size issue?

ve been focusing my time 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, >

Re: [sqlite] File size issue?

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

Re: [sqlite] File size issue?

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