Skip to site navigation (Press enter)

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

D. Richard Hipp 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]>

  • Previous message
  • View by thread
  • View by date
  • Next message

Reply via email to

The Mail Archive
  • The Mail Archive home
  • sqlite-users - all messages
  • sqlite-users - about the list
  • Expand
  • Previous message
  • Next message
sqlite-users
  • The Mail Archive home
  • Add your mailing list
  • FAQ
  • Support
  • Privacy
  • 1115247630.5453.43.camel@claire.hwaci.com