Comments | standardtom: The CPU cycles on...

standardtom

The CPU cycles on...

Dec 14, 2004 15:02

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.

Comments 18

cincycub December 14 2004, 13:04:52 UTC

OMG, I'd say there's somethin wrong there...

standardtom December 14 2004, 13:33:28 UTC

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.

cincycub December 14 2004, 13:40:35 UTC

Oh wow. Maybe it's time to rewrite :)

standardtom December 14 2004, 13:46:24 UTC

Rewrite?

The horror!

;-)

zoxobear December 14 2004, 13:08:46 UTC

Oracle $ $ $

standardtom December 14 2004, 13:38:32 UTC

Description of Oracle's worldview:

"Come into my parlor, said the spider to the fly."

zoxobear December 14 2004, 14:20:49 UTC

Oracle + Toad = Pie

standardtom December 15 2004, 08:22:24 UTC

I <3 Toad!

I use it every day.

mississippicub December 14 2004, 13:24:24 UTC

thats screwed up

standardtom December 14 2004, 13:37:22 UTC

Yeah.

But then, I am t3h 1n3ff1c13nt c0d3r!

quirkstreet December 14 2004, 13:43:11 UTC

I feeeeel your pain.

standardtom December 14 2004, 13:51:23 UTC

God I love that user icon.

But I digress... :-)

quirkstreet December 14 2004, 13:55:55 UTC

Well, thank you.

And it even exists in a larger format somewhere ... [leer]

standardtom December 14 2004, 14:07:29 UTC

Well now.

If I ask real nice, could I see the large-format version? My LJ email address works just fine. :-D

(The comment has been removed)

standardtom December 14 2004, 14:09:15 UTC

It actually was sifting through a lot of data, and doing some pretty involved subqueries inside a PL/SQL function. And the more I look at it, I'm beginning to think that my query was contending with someone else's that was running at the same time.

biguyfriend December 16 2004, 21:01:10 UTC

I was going to ask you if you were on your own db or on one that was shared by everyone? Plus, how many tables were involved here? anyway, I feel your pain...I am beginning to hate ALL queries... Hugs buddy, ya know I love ya.

standardtom December 17 2004, 16:04:43 UTC

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