I've been doing a big push to get major work done on my ontology lookup service before I leave for Munich tomorrow. I added a ton of new features and loaded an assload of new and interesting data on it.
Since this was all in development, all that code and data is on my laptop. It works fine. It takes about 2 hours to load 33 ontologies, 120000 terms and 790000 relationships between those terms. That's fairly decent – loading about 1000 terms a minute. Now, being all happy to get it done and wanting to deploy the friggin thing, I turn to the production servers. You'd think it would be blazingly faster, given the size of the things.
Of course not.
My load is about 10 times slower.
So I'll have to work late tonight if I want the last hour not to have been a complete waste of time.
Blergh.