Re: [sqlite] how to COPY FROM stdin in 3.x?

Wed, 04 May 2005 16:04:21 -0700

On Wed, 2005-05-04 at 17:21 -0400, Patrick Dunnigan wrote:
> Is this also true for for in memory databases? 

No.  ":memory:" databases are fast regardless of whether
or not your INSERT statements are enclosed in BEGIN..COMMIT.
Since ":memory:" databases do not have to worry about being
atomic and durable across power failures, they can get away
with a lot of things that a disk database cannot.
-- 
D. Richard Hipp <[EMAIL PROTECTED]>

Reply via email to