-Original Message-
From: Scott Derrick [mailto:[EMAIL PROTECTED]
Sent: Friday, July 20, 2007 8:54 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] quickest way to duplicate table data?
I am using sqlite in an embedded application. The data store table
will be in its own file.
In past non-SQLite contexts, I've found that the following usually
works very well, without needing snapshot capability:
1. copy the db file.
2. lock the db.
3. copy the db file.
4. unlock the db.
The first copy hopefully pulls the entire file into memory buffers,
making the next copy very