Explain advantage of Table Partitioning with bcp in Sybase

Question

Explain the advantage of Table Partitioning with bcp in Sybase?

Answer 1

You can take advantage of table partitioning with bcp in by following these guidelines:

1. Break up the data file into multiple files and simultaneously run each of these files as a separate bcp job against one table. Running concurrent jobs raises throughput

2. Select a number of partitions greater than the number of bcp jobs.
Having extra partitions than processes (jobs) reduces the probability of page lock contention.

3. Utilize the batch option of bcp in. For illustration, after every 100 rows, force a commit. Now there is the syntax of such command:

bcp table_name in filename -b100

All time a transaction commits, Adaptive Server Enterprise randomly assigns a new partition for the next insert. It, in turn, reduces the probability of page lock contention.