Re: [sqlite] Mechanism for pre-allocating contiguous files for Sqlite?

I'm writing a VFS right now. One of the parameters to the open is the file type (various types of DBs and journals). You should be able to use that info. Also, look for a took called config on the sysinternals site. It allows you to pre-allocate contiguous files. Better, it allows you to

Re: Re[2]: [sqlite] Mechanism for pre-allocating contiguous files for Sqlite?

Hi Teg, Isn't an open issued for the database and journal separately? I'm very familiar with the behavior for read-only, not so much for read/write... Regards, -- Gary On 10/28/07, Teg <[EMAIL PROTECTED]> wrote: > > Hello Gary, > > Sunday, October 28, 2007, 4:51:11 PM, you wrote: > > GM> Hi

Re[2]: [sqlite] Mechanism for pre-allocating contiguous files for Sqlite?

Hello Gary, Sunday, October 28, 2007, 4:51:11 PM, you wrote: GM> Hi Teg, GM> Have you considered the SQLite VFS? GM> Regards, GM> -- Gary GM> On 10/28/07, Teg <[EMAIL PROTECTED]> wrote: >> >> >> I'd like to pre-allocate the DB for Sqlite so, I can ensure it's a >> contiguous block of space

Re: [sqlite] Mechanism for pre-allocating contiguous files for Sqlite?

Hi Teg, Have you considered the SQLite VFS? Regards, -- Gary On 10/28/07, Teg <[EMAIL PROTECTED]> wrote: > > > I'd like to pre-allocate the DB for Sqlite so, I can ensure it's a > contiguous block of space on the disk. I'm aware of the "Insert a > bunch of data then delete" method but, it

[sqlite] Mechanism for pre-allocating contiguous files for Sqlite?

I'd like to pre-allocate the DB for Sqlite so, I can ensure it's a contiguous block of space on the disk. I'm aware of the "Insert a bunch of data then delete" method but, it doesn't ensure a contiguous block on disk. Is there some way I can allocate a file with OS calls and then use it as an