microsoft/mssql-jdbc

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

tkyc opened this issue · 0 comments

tkyc commented

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