Re: Poor Oracle performance?
Re: Poor Oracle performance?
- Subject: Re: Poor Oracle performance?
- From: Gavin Eadie <email@hidden>
- Date: Wed, 16 May 2007 11:51:55 -0400
At 2:13 PM -0400 5/15/07, Ken Anderson wrote:
I'm performing queries against Oracle using the thin style of connecting:
jdbc:oracle:thin:@<addr>:<port>:<SID>
When I use iSQL-Viewer to perform a query, the result set comes back
in under 100 milliseconds. When I do the same query with EOF, it
takes 16 seconds. When I break during this long period, it's always
here:
Very Interesting, Ken.
My colleague has a case where something like this happening. In his
case, a query issued by DBVisualizer takes about one second, and EO
takes over two minutes for the same* query. Moreover this only
happens when a query is made against one of a very small number of
records in the database.
I was in the middle of composing a detailed message with more
information when I saw Ken's message. One theory we have is that EOF
forms SQL queries with 'bindings' and DBVisualizer didn't, ie:
EOF: "... WHERE t0.ZONE_NAME = ?" withBindings: 1:"Phone"(zoneName)"
DBV: "... WHERE t0.ZONE_NAME = "Phone")
Note that in our case, when EOF repeats the same query, the response
is 'immediate' and woll remain 'immediate' for several hours. You
can imagine that this makes testing feel like the old days of
submitting a deck of cards and waiting till the next day to get your
printer output back!
Anyway, I wanted to get these comments in quickly in case any of it
helps Ken. I'll still be sending my more detailed report today ...
Gav
PS: Is there a way to tell EOF to not use "withBindings" in its SQL query??
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden