Skip to Content.
Sympa Menu

freetds - RE: 2000 && 4.2?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: 2000 && 4.2?
  • Date: 22 May 2002 13:47:47 -0700

On Wed, 2002-05-22 at 13:26, Lowden, James K wrote:
> > From: Daniel Morgan [mailto:danmorg AT sc.rr.com]
> > Sent: May 21, 2002 5:29 PM
> >
> > What is "bcp"?
>
> "bcp" stands for "bulk copy". It is the name Sybase gave to a feature of
> their server and TDS protocol.
>
> Normal INSERT statements are first applied to the transaction log and then
> applied to the table. A bcp insertion, OTOH, never touches the transaction
> log.

Actually - to be pedantic about it - the table allocations are still
logged (i.e. which pages get allocated during the insert).

And you can only run the non-logged (aka "fast") bcp if the target table
has no indexes and there are no triggers.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler AT peppler.org *or* mpeppler AT mbay.net
http://www.mbay.net/~mpeppler
International Sybase User Group: http://www.isug.com

Attachment: signature.asc
Description: This is a digitally signed message part




Archive powered by MHonArc 2.6.24.

Top of Page