Re: AW: [sqlite] Memory mapped db

2006-09-28 Thread John Stanton
Trevor Talbot wrote: Michael is referring to a direct map from disk pages to memory pages (OS notion of pages, not sqlite's), using something like mmap() on unix or MapViewOfFile() on Windows. This way memory is directly backed by the file it refers to, instead of copying the data to entirely

Re: AW: [sqlite] Memory mapped db

2006-09-28 Thread Trevor Talbot
Michael is referring to a direct map from disk pages to memory pages (OS notion of pages, not sqlite's), using something like mmap() on unix or MapViewOfFile() on Windows. This way memory is directly backed by the file it refers to, instead of copying the data to entirely new pages (possibly

Re: AW: [sqlite] Memory mapped db

2006-09-28 Thread Thomas . L
On Thu, 28 Sep 2006 15:45:54 +0200, you wrote: Hi Michael >-Ursprüngliche Nachricht- >Von: Jay Sprenkle [mailto:[EMAIL PROTECTED] >Gesendet: Donnerstag, 28. September 2006 15:37 >An: sqlite-users@sqlite.org >Betreff: Re: [sqlite] Memory mapped db >That's not really

Re: [sqlite] Memory mapped db

2006-09-28 Thread Kees Nuyt
On Thu, 28 Sep 2006 15:32:03 +0200, you wrote: > >Has anyone tested an sqlite which memory-maps the db-file into ram? Is this >an old (maybe bad idea :-) ? I've looked over the source and it seems that >read and write operations are used through a singled interface, so it maybe >possible to

Re: [sqlite] Memory mapped db

2006-09-28 Thread John Stanton
Michael Wohlwend wrote: Has anyone tested an sqlite which memory-maps the db-file into ram? Is this an old (maybe bad idea :-) ? I've looked over the source and it seems that read and write operations are used through a singled interface, so it maybe possible to implement it without too much

AW: [sqlite] Memory mapped db

2006-09-28 Thread Michael Wohlwend
-Ursprüngliche Nachricht- Von: Jay Sprenkle [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 28. September 2006 15:37 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Memory mapped db >use the database named:memory: >for a ram database. In a lot of cases it will be

Re: [sqlite] Memory mapped db

2006-09-28 Thread Jay Sprenkle
use the database named:memory: for a ram database. In a lot of cases it will be cached by the operating system so it ends up being that way anyway! On 9/28/06, Michael Wohlwend <[EMAIL PROTECTED]> wrote: Has anyone tested an sqlite which memory-maps the db-file into ram? Is this an old

[sqlite] Memory mapped db

2006-09-28 Thread Michael Wohlwend
Has anyone tested an sqlite which memory-maps the db-file into ram? Is this an old (maybe bad idea :-) ? I've looked over the source and it seems that read and write operations are used through a singled interface, so it maybe possible to implement it without too much trouble... Any comments