Another novice question: Does this run in its separate process or is directly linked into the application requiring access to the stored data. I don't want a crash in any of my embedded modules to crash the database as well.
On Thu, 07 Oct 2004 07:44:43 -0400, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > > R S wrote: > > I was trying to find info for the same, but couldn't. Do let me know. > > > > SQLite normally operates off of disk. It reads a little from the > disk as it can get by with, but once it reads from the disk it > caches information in memory in case it has to reuse it later. > The size of the memory cache is limited by default to 2MB, but > you can change this at runtime using a pragma. > > If, however, you open the special database file named ":memory:" > it will create an empty in-memory only database that you can use > for temporary storage. > > -- > D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 > >