New project, 22 million record base, CRAP IO, lots of pain.
I could do nothing until I had a bunch of indexes, and those took ~3-4 minutes each. And looking for both OLD/NEW/Field info meant I needed to index twice for each field that I wanted to query. If I to try to do any type of complete list of fields, I'd be here for the next 2 days just indexing.
And the board meeting is 9AM, they need the report, or the project is possibly canceled.
So I started a limited set of indexes to give me a decent baseline of fields, and let it grind.
I knew I couldn't do anything until done, and went to sleep, setting my alarm for 4AM (estimated ETA, but impossible to predict).
I popped out of bed at 2:41, made coffee, and logged in at 2:45. The indexing had completed at 2:41. Exactly. The moment I woke up. On the dot. Last timestamp on file.
It was calling me.