AW: [sqlite] Memory mapped db

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

[sqlite] Memory mapped db

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 are

AW: AW: [sqlite] Performance question

-Ursprüngliche Nachricht- Von: Martin Pfeifle [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 26. September 2006 13:35 An: sqlite-users@sqlite.org Betreff: AW: AW: [sqlite] Performance question >Hi Michael, >could you please (re)post the exact create inex statements +primary key you used

AW: [sqlite] Performance question

-Ursprüngliche Nachricht- Von: Dennis Cote [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 22. September 2006 17:07 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Performance question Michael Wohlwend wrote: > But If I do "select data from pictures where (x between hi

AW: [sqlite] Performance question

-Ursprüngliche Nachricht- Von: Gerald Dachs [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 22. September 2006 11:28 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Performance question >My sql knowledge may be a little bit rusty and I have really no idea how sqlite is doing "between"

[sqlite] Performance question

Hi, I made a database of little pictures, which includes x und y coordinates and a blob (between 100 and 8000 bytes in size, one blob, total db size 180MB). If I do "select data from pictures where x=? And y=?" this works well, also on wince (measured myself: 1 such a select take 5 millisecond