Skip to Content

Sybase ASE. How to tell bcp is fast or slow

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 30, 2017 at 09:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded