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.

I would define them as follows:

• Declaration: This thing exists.
• Definition: Here are the details for how this thing works.
• Initialization: Assign the initial state to this thing.
• Assignment: The value of this thing is now X.

I keep getting an invalid address on my devices, but I’m really interested in watching this. Is there any other link or am I doing something wrong?

Oh yeah that’s a great alternate option too if your mobile plan includes tethering. I’ve successfully used both Android and iOS tethering in the past and it was pretty seemless each time.

Wi-Fi drivers are notoriously complicated on Linux in general, though things have been improving. But yeah if ‘iwctl device list’ comes up empty when you plan to use Wi-Fi to install Arch, especially if Ethernet isn’t a viable temporary alternative because your device doesn’t have an Ethernet port, you’re in for a tough time.

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.