OK - that was no help. I created a completely independent project
that just did the one query, and it still takes too long...
On May 16, 2007, at 4:31 PM, Ken Anderson wrote:
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?
From: webobjects-dev-bounces
[EMAIL PROTECTED] [mailto:webobjects-dev-
[EMAIL PROTECTED] On Behalf Of Gavin
Eadie
Sent: Wednesday, May 16, 2007 4:07 PM
To: Ken Anderson; Art Isbell
Cc: WebObjects Dev Apple
Subject: Re: Poor Oracle performance?
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/kenlists%
40anderhome.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
