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] standardtom.livejournal.com 2004-12-17 04:04 pm (UTC)(link)
Hey :-)

It was most definitely a shared db... it was the main Oracle database that the whole university shares. So, it had occurred to me that I might have been contending with someone else.

Also, it wasn't but two or three tables. A lot of the actual activity was being generated most likely by the PL/SQL function, which was doing something with addresses that's pretty intensive.

Of course I know you love me. Ditto. :-D