Re: [sqlite] Is this an in-memory database too

2004-10-07 Thread mike cariotoglou
> It would usually make more sense to do the following: > > BEGIN TRANSACTION; > ... inserts,updates,deletes > COMMIT; > > You get pretty much the same affect, but it is safe. Setting yes, I am aware of this, of course. what I am saying is : since there *is* a cache, and since we *can* modify its

Re: [sqlite] Is this an in-memory database too

2004-10-07 Thread mike cariotoglou
> Yes, I was a trifle optimistic with my estimates > > On an operating system with a sensible I/O scheduler (I cannot say > whether or not windows qualifies) it should normally take about > two complete rotations of the disk platter to complete a write. > Obviously a large change would take

Re: [sqlite] Is this an in-memory database too

2004-10-07 Thread D. Richard Hipp
mike cariotoglou wrote: > - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: > <[EMAIL PROTECTED]> Sent: Thursday, October 07, 2004 7:10 PM Subject: > Re: [sqlite] Is this an in-memory database too > >> Yes. As many different pro

Re: [sqlite] Is this an in-memory database too

2004-10-07 Thread mike cariotoglou
- Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 07, 2004 7:10 PM Subject: Re: [sqlite] Is this an in-memory database too > Yes. As many different processes as you want can read the database >

Re: [sqlite] Is this an in-memory database too

2004-10-07 Thread R S
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

Re: [sqlite] Is this an in-memory database too

2004-10-07 Thread D. Richard Hipp
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

Re: [sqlite] Is this an in-memory database too

2004-10-07 Thread Jake Skinner
Cory Nelson wrote: nope, runs entirely off disk. On Wed, 6 Oct 2004 23:18:12 -0700, R S <[EMAIL PROTECTED]> wrote: I was trying to find info for the same, but couldn't. Do let me know. Ummm actually SQLite can be an in-memory database. Check this out:

Re: [sqlite] Is this an in-memory database too

2004-10-07 Thread Cory Nelson
nope, runs entirely off disk. On Wed, 6 Oct 2004 23:18:12 -0700, R S <[EMAIL PROTECTED]> wrote: > I was trying to find info for the same, but couldn't. Do let me know. > -- Cory Nelson http://www.int64.org

[sqlite] Is this an in-memory database too

2004-10-07 Thread R S
I was trying to find info for the same, but couldn't. Do let me know.