Re: [sqlite] Enhancements for SQLite
On 9/27/05, Christopher Petrilli <[EMAIL PROTECTED]> wrote: > > On 9/27/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > > I'm developing an open source project (a Data Access Grid) that > > > uses internally the SQLite library as the storage method and I'm > > > interested in your opinion about 4 questions: > > > > > > 1) SQLite can't deal with raw devices. Should be hard to patch the > > > source to deal with raw devices? > > > > You'll have to write your own file system code (with locking). > > Seriously though, there's no reason for this. It's not going to help > on performance unless you also add all sorts of multi-spindle > management code. Having worked a lot with Oracle on raw-devices, it's > only beneficial when you can throw lots of different spindles at it. It might be good if you're implementing on many operating systems that don't all do file system locking the same way or even at all...
Re: [sqlite] Enhancements for SQLite
On Tue, 2005-09-27 at 13:40 +0200, Joxean Koret wrote: > Why not use mmap, munmap, mprotect, mlock, etc... system calls? > You ever tried to mmap a 10GiB database file into the memory of processor with a 4GiB address space? -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] Enhancements for SQLite
On 9/27/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > I'm developing an open source project (a Data Access Grid) that > > uses internally the SQLite library as the storage method and I'm > > interested in your opinion about 4 questions: > > > > 1) SQLite can't deal with raw devices. Should be hard to patch the > > source to deal with raw devices? > > You'll have to write your own file system code (with locking). Seriously though, there's no reason for this. It's not going to help on performance unless you also add all sorts of multi-spindle management code. Having worked a lot with Oracle on raw-devices, it's only beneficial when you can throw lots of different spindles at it. Chris -- | Christopher Petrilli | [EMAIL PROTECTED]
Re: [sqlite] Enhancements for SQLite
On 9/27/05, Joxean Koret <[EMAIL PROTECTED]> wrote: > > Hi list! > > I'm developing an open source project (a Data Access Grid) that > uses internally the SQLite library as the storage method and I'm > interested in your opinion about 4 questions: > > 1) SQLite can't deal with raw devices. Should be hard to patch the > source to deal with raw devices? You'll have to write your own file system code (with locking).