FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

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