[personal profile] standardtom

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.

Date: 2004-12-14 02:09 pm (UTC)
From: [identity profile] standardtom.livejournal.com
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.

Date: 2004-12-16 09:01 pm (UTC)
From: [identity profile] biguyfriend.livejournal.com
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.

Date: 2004-12-17 04:04 pm (UTC)
From: [identity profile] standardtom.livejournal.com
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

Profile

standardtom

August 2014

S M T W T F S
     12
3456 789
10111213141516
17181920212223
24252627282930
31      

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 14th, 2025 09:50 am
Powered by Dreamwidth Studios