Re: [sqlite] Periodical dump of in-memory database into a disk file

I tried this and it did not seem to make any difference.   Basically, I open my main database :memory: first and then set "PRAGMA synchronous = OFF".  After I "ATTACH diskfile AS external", I just periodically do "BEGIN; DELETE FROM external.tables; INSERT INTO external.tables SELECT * FROM

Re: [sqlite] Periodical dump of in-memory database into a disk file

You can try to help your issue by running "PRAGMA synchronous = OFF;" after you open your connection. Cheers, Shawn Wilsher Mozilla Developer On Thu, Jul 10, 2008 at 3:04 PM, X Wang <[EMAIL PROTECTED]> wrote: > Hi, I have a sqlite in-memory databse that I want to periodically dump to a > disk

[sqlite] Periodical dump of in-memory database into a disk file

Hi, I have a sqlite in-memory databse that I want to periodically dump to a disk file (so I can look into its contents at runtime). Currently I "ATTACH" an extern file. Periodically I export everything from in-memory databse into the attached extern file and do a final COMMIT. However, this