standardtom ([personal profile] standardtom) wrote2004-12-14 03:02 pm

The CPU cycles on...

An SQL statement I started running three hours ago has only just now finished.

And it only inserted 85 frippin' rows.

I feel very cheated.

[identity profile] cincycub.livejournal.com 2004-12-14 01:04 pm (UTC)(link)
OMG, I'd say there's somethin wrong there...

[identity profile] standardtom.livejournal.com 2004-12-14 01:33 pm (UTC)(link)
It was pretty cobbled-together anyway. But I still didn't expect it to take THAT long.

It was comparing the results of a function-within-a-function to a large IN clause.

[identity profile] cincycub.livejournal.com 2004-12-14 01:40 pm (UTC)(link)
Oh wow. Maybe it's time to rewrite :)

[identity profile] standardtom.livejournal.com 2004-12-14 01:46 pm (UTC)(link)
Rewrite?

The horror!

;-)