Azure / Azure/elastic-db-tools
MSQ: Implement CommandBehavior.SequentialAccess in MultiShardCommand
Open
- Dominant language
- C#
- Stars
- 147
- Forks
- 108
- PR merge metrics
- No merged PRs in 30d
Description
In scenarios where large rows are being read, using CommandBehaviors.SequentialAccess in SqlCommand.ExecuteReader() can improve performance because it avoids caching the entire row in memory. Some users of MSQ, possibly include SQL Azure Global Query, may find it useful for MultiShardCommand to also support CommandBehaviors.SequentialAccess in order to get this potential perf increase.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.