Been a little while since I worked on ODBC stuff, but I have a couple of thoughts:
Would it be possible to use something like a table function on the DB side to simplify the query from the ODBC side?
I could be misremembering, but I feel like looping through individual inserts with an open connection was faster than trying to submit data in bulk when inserting that much data in one shot. Might be worth doing a benchmark in a test DB and table to confirm.
I know I was able to insert more than 50M rows in a manner of single digit hours, but unfortunately don’t have access to that codebase anymore to double check the specifics.
Been a little while since I worked on ODBC stuff, but I have a couple of thoughts:
Would it be possible to use something like a table function on the DB side to simplify the query from the ODBC side?
I could be misremembering, but I feel like looping through individual inserts with an open connection was faster than trying to submit data in bulk when inserting that much data in one shot. Might be worth doing a benchmark in a test DB and table to confirm.
I know I was able to insert more than 50M rows in a manner of single digit hours, but unfortunately don’t have access to that codebase anymore to double check the specifics.