Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLServerBulkCopy destination column metadata is caching but is not reusing the results, so metadata calls are repeated #2224

Closed
tkyc opened this issue Sep 28, 2023 · 0 comments · Fixed by #2231

Comments

@tkyc
Copy link
Contributor

tkyc commented Sep 28, 2023

When performing a bulk insert, the driver does a destination column metadata query. However, this metadata query is repeated if the bulk insert is repeated. It isn't necessary to repeat the call if the destination columns did not change.

The metadata query being ran is the following:

select collation_name, encryption_type from sys.columns where object_id=OBJECT_ID('table') order by column_id ASC

@Jeffery-Wasty Jeffery-Wasty added the From external source An issue received outside of GitHub, but tracked on GitHub. label Sep 28, 2023
@lilgreenbird lilgreenbird removed the From external source An issue received outside of GitHub, but tracked on GitHub. label Oct 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Closed Issues
Development

Successfully merging a pull request may close this issue.

3 participants