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