I’ve made extensive use of bulk insert for onboarding and similar tasks. Unless I’m mistaken, one of the main reasons this runs rapidly is that much of the work is done locally on the server as opposed to sending up a large number of INSERT queries.

I am attempting to optimize some very ugly queries. I have this query here that is grabbing the abbreviation for a state since we are only working with abbreviations.