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.

Automation. My phone automatically triggers API calls, settings tweaks, launches apps to specific pages/playlists, and collects usage statistics to a local and private location all on its own. This means I only get a day and a half of battery life, but the tradeoff is well worth it in my opinion.