Re: Poor Oracle performance?
Re: Poor Oracle performance?
- Subject: Re: Poor Oracle performance?
- From: Ken Anderson <email@hidden>
- Date: Wed, 16 May 2007 12:09:21 -0400
Thanks Gavin. Yes, I had thought about the fact that bindings are
used in one, but not the other. Unfortunately, I haven't been able
to figure out how to do bindings with the tool, or no bindings with EOF.
Unfortunately, the performance of the same query is identical after
multiple iterations.
Ken
On May 16, 2007, at 11:51 AM, Gavin Eadie wrote:
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:
40anderhome.com
This email sent to email@hidden
_______________________________________________
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