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.

This seems super interesting and I’ve never heard of it before. Thanks for sharing!

Is this more of a table top game? I’d be interested to see it as a kind of MMO.

Those aren’t really the same apps between the two systems, even if most of them still have the same names. Not only do the modem versions have more features, but they also have updated designs, window chrome, and use more secure underpinnings.

Compare the boot times, network speeds, ease and speed of installing new software, and security of the same old vs. new systems, and the new stuff will come out on top every time.