> 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
Mike,
"mike cariotoglou" <[EMAIL PROTECTED]>
08/10/2004 11:16 AM
Please respond to sqlite-users
To: <[EMAIL PROTECTED]>
cc:
Subject: Re: [sqlite] Is this an in-memory database too
> assume that I can live with the database b
> 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 mor
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
- 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
>
R S wrote:
Hi Richard,
Thanks for your answers,
On Thu, 07 Oct 2004 11:35:08 -0400, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
R S wrote:
Another novice question:
Does this run in its separate process or is directly linked into the
application requiring access to the stored data.
It is a subrou
Hi Richard,
Thanks for your answers,
On Thu, 07 Oct 2004 11:35:08 -0400, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> R S wrote:
> > Another novice question:
> > Does this run in its separate process or is directly linked into the
> > application requiring access to the stored data.
>
> It i
R S wrote:
Another novice question:
Does this run in its separate process or is directly linked into the
application requiring access to the stored data.
It is a subroutine in your code.
I don't want a crash in any of my embedded modules to crash the
database as well.
It won't. SQLite takes great
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]>
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 cac
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:
http://www.sqlite.org/cvstrac/wiki
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
I was trying to find info for the same, but couldn't. Do let me know.
13 matches
Mail list logo