bcp performance optimization

In earlier versions, Adaptive Server used fast bcp when sp_dboption 'select into/bulkcopy/pllsort' was enabled and the table had no indexes or triggers.

In all other cases, Adaptive Server used slow bcp.

If a table had indexes or triggers, you had to drop these before using fast bcp and then recreate them after loading the data with bcp.

Adaptive Server version 15.0.2 allows you to use fast bcp to copy data into tables with non-clustered indexes or triggers, improving Adaptive Server’s performance for inserting huge volumes of data. With this optimization the use of slow bcp is now only required when:

In all other cases, Adaptive Server uses fast bcp.

These are situations in which Adaptive Server version 15.0.2 uses fast bcp but earlier versions Adaptive Server used slow bcp (in all cases sp_dboption ‘select into/bulkcopy/pllsort’ is enabled and the table does not have a clustered index):

If the table includes nonclustered indexes or triggers, but sp_dboption 'select into/bulkcopy/pllsort' is not enabled, Adaptive Server uses slow bcp, and prints this warning message to indicate that you can improve the performance of bcp by enabling sp_dboption 'select into/bulkcopy/pllsort':

Performing slow bcp on table '%s'. To enable fast bcp please turn on 'select into/bulkcopy' option on the database '%s

bcp optimizatin is performed by Adaptive Server and does not require that you use Open Client version 15.0 or later.