ct: RE: [sqlite] A Question About Creating and Accessing a SQLite Database
in a RAM Drive
> Rich,
>
> We're going to delete and rewrite ~109,369 records in 5 tables
> every week.
>
>
> Hard drives are a minimum of 10,000 times slower than RAM. I'll
> let you
> know if this
it!
*
- Original Message -
From: Rich Shepard <[EMAIL PROTECTED]>
Date: Wednesday, August 22, 2007 1:14 am
Subject: RE: [sqlite] A Question About Creating and Accessing a SQLite Database
in a RAM Drive
> O
drive.
Lee Crain
_
-Original Message-
From: Rich Shepard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 21, 2007 11:15 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] A Question About Creating and Accessing a SQLite
Database
5 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] A Question About Creating and Accessing a SQLite
> Database in a RAM Drive
>
> On Tue, 21 Aug 2007, Lee Crain wrote:
>
> > The approach I planned was a little different than what you proposed.
>
>That's fi
_
-Original Message-
From: Rich Shepard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 21, 2007 11:15 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] A Question About Creating and Accessing a SQLite
Database in a RAM Drive
On Tue, 21 Aug 2007, Lee Crain wrote
On Tue, 21 Aug 2007, Lee Crain wrote:
The approach I planned was a little different than what you proposed.
That's fine, Lee.
This technique for performing database updates offline and then updating
the original database via a file copy operation has worked very well on
hard drives. I am
-Original Message-
From: Rich Shepard [mailto:[EMAIL PROTECTED]
Sent: Monday, August 20, 2007 5:36 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] A Question About Creating and Accessing a SQLite
Database in a RAM Drive
On Mon, 20 Aug 2007, Lee Crain wrote
7 7:35 am
Subject: Re: [sqlite] A Question About Creating and Accessing a SQLite Database
in a RAM Drive
> On Mon, 20 Aug 2007, Lee Crain wrote:
>
> > Is there any reason why this would not be possible?
>
> Lee,
>
> Not at all. You can create the databse in memory as
On Mon, 20 Aug 2007, Lee Crain wrote:
Is there any reason why this would not be possible?
Lee,
Not at all. You can create the databse in memory as long as you have
sufficient storage for it. See the web pages for syntax. If you do not
specify a filename when you invoke sqlite3, it's an
Is there any reason why this would not be possible?
Data persistence is not required.
Thanks,
Lee Crain
-
To unsubscribe, send email to [EMAIL PROTECTED]
10 matches
Mail list logo