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

SQL Server BCP based load enhancements #589

Closed
sm-shaw opened this issue Sep 1, 2023 · 0 comments · Fixed by #592
Closed

SQL Server BCP based load enhancements #589

sm-shaw opened this issue Sep 1, 2023 · 0 comments · Fixed by #592
Labels
build database Database specific enhancement New feature or request

Comments

@sm-shaw
Copy link
Contributor

sm-shaw commented Sep 1, 2023

PR #587 has added BCP based loads to the TPROC-C schema for SQL Server that are at least 2X faster than the default insert based loads.
Potential further enhancements are:

  1. Currently, SQL authentication is supported, adding the -T flag could also use Windows authentication and then BCP based loads could become the default.
  2. BCP based loads could be added to the TPROC-H schema.
  3. extending the tdbc::odbc interface to add the bcp_init, bind and sendrow commands and call these directly from ODBC rather than the external bcp command
    https://learn.microsoft.com/en-us/sql/relational-databases/native-client-odbc-extensions-bulk-copy-functions/bcp-init?view=sql-server-ver16
    https://learn.microsoft.com/en-us/sql/relational-databases/native-client-odbc-extensions-bulk-copy-functions/bcp-bind?view=sql-server-ver16
    https://learn.microsoft.com/en-us/sql/relational-databases/native-client-odbc-extensions-bulk-copy-functions/bcp-sendrow?view=sql-server-ver16
@sm-shaw sm-shaw added enhancement New feature or request database Database specific build labels Sep 1, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
build database Database specific enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant