Re: [sqlite] Dumping Memory-DB to File

A very simple way is use an exclusively opened file as a lock. RohitPatel wrote: Hi I need some help on this. I need to create a new SQLite database with all necessary tables, records and indices. Database file must be removed from disk if any error while creating/copying tables, records o

Re: [sqlite] Dumping Memory-DB to File

Hi I need some help on this. I need to create a new SQLite database with all necessary tables, records and indices. Database file must be removed from disk if any error while creating/copying tables, records or indices. Other application or other instance of same app must not be able to access t

Re: [sqlite] Dumping Memory-DB to File

Hello everyone, thanks for your replies. I will try to speed things up by using transactions. Cheers + happy weekend, Henning -- View this message in context: http://www.nabble.com/Dumping-Memory-DB-to-File-t1592559.html#a4353870 Sent from the SQLite forum at Nabble.com.

Re: [sqlite] Dumping Memory-DB to File

--- Henning Friese <[EMAIL PROTECTED]> wrote: > Joe Wilson wrote: > > > > :memory: is faster if you're not using transactions. > > > > Hello Joe, > > thanks for your answer. I'm not using transactions, I would recommend using file-based database transactions, as it is often faster than :memo

Re: [sqlite] Dumping Memory-DB to File

Griggs, Donald wrote: If your question still persists in the form of, "Is there a one-call method in the API to write out any :memory: database to disk?", then I think the answer is, "No, if ATTACH is too cumbersome, you would need to write your own code as you see fit." Henning, Using a tra

RE: [sqlite] Dumping Memory-DB to File

Systems nor its board of directors. -Original Message- From: Henning Friese [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 3:51 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Dumping Memory-DB to File Joe Wilson wrote: > > :memory: is faster if you're not using tran

Re: [sqlite] Dumping Memory-DB to File

Joe Wilson wrote: > > :memory: is faster if you're not using transactions. > Hello Joe, thanks for your answer. I'm not using transactions, I'm just doing a lot of "INSERT INTO"s with a huge amount of data. It seems to be faster doing that in a ":memory:"-db (I've already tried that). I just

Re: [sqlite] Dumping Memory-DB to File

--- Henning Friese <[EMAIL PROTECTED]> wrote: > I'm using SQLite with the ADO .NET - Povider and I'd like to create a > database in memory, insert data into it and then save it to a file (for > performance reasons). Your assumption may not be correct. This is counter-intuitive but, for newly crea