2000 && 4.2?

Michael Peppler mpeppler at peppler.org
Fri May 2 19:13:14 EDT 2003


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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: This is a digitally signed message part
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20020522/1da791b5/attachment.bin


More information about the FreeTDS mailing list