Rich, The approach I planned was a little different than what you proposed.
I've done some experimentation with updating a SQLite database by overwriting it with an updated copy of the database. It's a simple file overwrite, it's fast, and the database, with its new data contents, is fully useable. My plan: 1. Create a RAM drive. 1. Copy a hard drive based SQLite database from its hard drive to a RAM drive. 2. Perform updates to the SQLite database in the RAM drive (for speed). 3. Copy the RAM based SQLite database back to the hard drive and overwrite the original SQLite database. 4. Delete the RAM drive. 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 only considering using the RAM drive to improve the speed of the database updates. Lee Crain ________________________________ -----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: > 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 in-memory database on which you can perform all SQL operations. Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 -------------------------------------------------------------------------- --- To unsubscribe, send email to [EMAIL PROTECTED] -------------------------------------------------------------------------- --- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
