Inserting LOTW files should be pretty easy, actually.
Yep. As I've monitored the numbers over the last few weeks and have done the math, they are processing at most 2-3 QSOs per second. Even though they're dealing with a fair amount of data to query, this is extremely
slow. I'd expect no more than a few milliseconds per transaction. My experience has shown that unless you are very seriously underpowered, hardware upgrades are simply a temporary bandaid on a more serious database/query design problem.
Not to compare LoTW to Google, but I'm always amazed how Google can query about 100 billion web pages (they index or re-index about 20 billion per day) and give me useful results in less time than it takes me to search for a filename in a folder on my own hard drive.
Check my math, but at 3 QSOs per second, it will take 35 days to get to a log submitted today processed. So it is too late to submit a log for DXCC year end processing. It also means that it will not catch up before the RTTY roundup logs hit.