Performance - Align ImportTableBatchHelper BulkCopy BatchSize with Clustered Columnstore Index guidance
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 460
- Forks
- 29
- Avg merge
- 4d 9h
- Merged PRs (30d)
- 7
Description
**Is your feature request related to a problem? Please describe.**
Importing bacpacs is extremely slow and resource intensive.
**Describe the solution you'd like**
In the ImportTableBatchHelper, the Batch Size is configure to `int.MaxValue`, while the guidance for Clustered Columnstore Index loading is 1048576 ([Smart Bulk Copy](https://github.com/Azure-Samples/smartbulkcopy) respects this behavior)
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Locate ImportTableBatchHelper and inspect how its bulk-copy BatchSize is configured. Compare the current value with the linked Clustered Columnstore Index guidance and Smart Bulk Copy behavior, then verify that bacpac imports use 1048576 without introducing regressions.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, sql
- Domain
- database
- Issue type
- Feature
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100