Re: Poor Oracle performance?
Re: Poor Oracle performance?
- Subject: Re: Poor Oracle performance?
- From: Ken Anderson <email@hidden>
- Date: Wed, 16 May 2007 16:31:13 -0400
| Thanks Chris, but no - it's not. The query is only returning a few rows.
I'm working on building an app that performs the query without any of my other frameworks - I'm wondering if some jar is in the classpath that's mucking things up...
On May 16, 2007, at 4:28 PM, Lonie, Chris wrote: Is it possible that the table is set to be cached in memory?
At 3:33 PM -0400 5/16/07, Gavin Eadie wrote: Unfortunately, that doesn't seem to do anything - so no way to tell...
I concur, with Oracle and OpenBase - that setting has no effect (and its default is false anyway) .. Gav
... onwards, we dig! I note, from Carl Lindberg in November 2003:
There's even a way to turn bind variables on or off using a startup parameter, but unfortunately JDBCExpression overrides all these methods to forcibly always use bind variables (thus ignoring the startup parameter -- at least with WO 5.1.x).
|
_______________________________________________
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