Skip to Content
0

Sybase ASE. How to tell bcp is fast or slow

Nov 30, 2017 at 09:16 PM

93

avatar image

I would like to know whether a bulk copy operation, seen as BULK INSERT with sp_who, is a fast or slow bcp in. That is, whether it is fully or minimally logged.

ASE 15.7 SP52

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Avinash Kothare Nov 30, 2017 at 09:47 PM
0

sp_who shows you some process details for each SPID including partial command details under "CMD" column.

bcp is fast (non-logged) based on how the table & database are configured.

- Database option "bulkcopy" must be true/enabled

- No indexes on table

- No triggers (or disabled triggers)

Otherwise bcp is slow i.e. logged

And this is NOT visible via output of sp_who.

HTH

Avinash

Share
10 |10000 characters needed characters left characters exceeded