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 have to copy the db into ram after >opening it and since the db is too big to fit into the memory I would have >to recreate it dependend on my selects. >If sqlite maps the db into memory, the operating system manages the mapping, >sqlite "just" has to move it's view over the file. I'm working with some "small" SQLite databases, with less than 150.000 Records (Extractions of a bigger CS-DB). The records a stored in several Tables. One Table with 4000-5000 Records are bigger, the rest up to limit are smaller. I'm using SQlite to do some quickly jobs with the data on a local machine. I read and load the whole Result, opened by a SQL-Query, as a virtual table into a RAM's Vector-List. If this done, I can read Record by Record, forward, backward, skip any direction, alter, append new record, delete records. I can all do, what I want.... It seems to me, I do that, who you ask. But... I don't know, which developer-System you are using. I am working with VC++ .Net 2003. If that wrong to you, excuse the disturbance ;-) Is it OK, spend some time at my HP. Best Regards Thomas www.thlu.de ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
