FASTTRANSFER_SORTEDINPUT
Forces the sorted input hint for SQL Server bulk copy operations when using the msbulk target connection type.
Overview
| Property | Value |
|---|---|
| Connection Types | msbulk |
| Default Value | false |
| Valid Values | true, false |
| Since Version | 0.17 |
Description
When set to true, FastTransfer instructs SQL Server's bulk copy API to treat incoming data as sorted according to the clustered index. This can significantly improve performance when:
- The source data is already sorted by the target table's clustered index columns
- The target table has a clustered index
- You want to minimize page splits and fragmentation
Usage
- Windows
- Linux
Temporary (current session):
# Enable sorted input hint
set FASTTRANSFER_SORTEDINPUT=true
# Run FastTransfer
./FastTransfer --targetconnectiontype msbulk ...
Temporary (current session):
# Enable sorted input hint
export FASTTRANSFER_SORTEDINPUT=true
# Run FastTransfer
./FastTransfer --targetconnectiontype msbulk ...