Sqlite maintains its data in a disk file. It only reads and writes to
that file sufficient bytes to maintain changes to the database or to
satisfy the query. It uses memory to cache data while it processes it
and will write changed parts of that data back to the disk file.
Fundamentally
Igor Tandetnik wrote:
> <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>
>> I understand that the SQLite database resides in memory.
>>
>
> Not usually, no. There's an in-memory cache of recently accessed pages,
> but most of the database (especially a large database)
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I understand that the SQLite database resides in memory.
Not usually, no. There's an in-memory cache of recently accessed pages,
but most of the database (especially a large database) remains on disk.
> Now lets say a database is
I understand that the SQLite database resides in memory. I understand that
the information in memory gets written to disk, ie saving parts that have
been updated/whole database.
I have read that SQLite has been known to support up 100,000 concurrent
read connections and can support several
4 matches
Mail list logo