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 the same. I would

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 cached by >the