On May 16, 2007, at 9:33 AM, Gavin Eadie wrote:
I concur, with Oracle and OpenBase - that setting has no effect (and its default is false anyway) .. Gav
I see that JDBCExpression overrides EOSQLExpression's useBindVariables() to always return true. And OraclePlugIn.OracleExpression, a JDBCExpression subclass, doesn't override useBindVariables(), so the Oracle plugin must be set to use bind variables regardless of the value of EOAdaptorUseBindVariables.
That said, I'd be surprised that merely using bind variables would cause the poor fetch performance. In fact, I thought that bind variable usage was supposed to help the query optimizer improve performance, but my memory might be faulty.
Aloha, Art _______________________________________________ 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]
