Re: [sqlite] Writing an in-memory database to file

[D. Richard Hipp]

Gerhard Haering wrote:
On Tue, Nov 02, 2004 at 12:37:23PM +0100, Oliver Bienert wrote:
Hello all,
I wonder if there is a possibility to save (dump) an in-memory
database to file (and vice versa, loading from file) in a fast way?
(Without having to create a new database and copying records by
select and inserts)

There is none. Did you actually try INSERT ... SELECT and found the
performance inadequate?
Use ATTACH to attach the file database to your in-memory
database.  Then do a
   INSERT INTO file.table1 SELECT * FROM main.table1;
for each table.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] Writing an in-memory database to file

[Gerhard Haering]

On Tue, Nov 02, 2004 at 12:37:23PM +0100, Oliver Bienert wrote:
> Hello all,
> 
> I wonder if there is a possibility to save (dump) an in-memory
> database to file (and vice versa, loading from file) in a fast way?
> (Without having to create a new database and copying records by
> select and inserts)

There is none. Did you actually try INSERT ... SELECT and found the
performance inadequate?

-- Gerhard
-- 
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?


signature.asc
Description: Digital signature

[sqlite] Writing an in-memory database to file

[Oliver Bienert]

Hello all,
I wonder if there is a possibility to save (dump) an in-memory database 
to file (and vice versa, loading from file) in a fast way? (Without 
having to create a new database and copying records by select and inserts)

Oliver