Ken,
Have you logged the SQL to see if your pause is occurring during, or
after the SELECT completes? Whenever I've had performance problems
that seemed like database problems it was generally happening after
the select while building the objects, rather than the actual request
performance.
On May 15, 2007, at 2:13 PM, Ken Anderson wrote:
Everyone,
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:
EODatabaseChannel._selectWithFetchSpecificationEditingContext
(EOFetchSpecification, EOEditingContext) line: 878
JDBCChannel.selectAttributes(NSArray, EOFetchSpecification,
boolean, EOEntity) line: 185
JDBCChannel.evaluateExpression(EOSQLExpression) line: 261
JDBCChannel._evaluateExpression(EOSQLExpression, boolean, boolean)
line: 303
JDBCChannel._bindInputVariablesWithBindingsAndExecute(NSArray,
String, Connection, boolean, boolean) line: 230
T4CPreparedStatement(OraclePreparedStatement).execute() line: 2976
T4CPreparedStatement(OraclePreparedStatement).executeInternal()
line: 2885
T4CPreparedStatement(OracleStatement).doExecuteWithTimeout() line:
984
T4CPreparedStatement.execute_maybe_describe() line: 694
T4CPreparedStatement(OracleStatement).execute_maybe_describe()
line: 913
T4CPreparedStatement.execute_for_rows(boolean) line: 785
T4CPreparedStatement.doOall8(boolean, boolean, boolean, boolean)
line: 182
T4C8Oall.receive() line: 435
T4CMAREngine.unmarshalSB1() line: 951
T4CMAREngine.unmarshalUB1() line: 979
NetInputStream.read() line: not available
NetInputStream.read(byte[]) line: not available
NetInputStream.read(byte[], int, int) line: not available
NetInputStream.getNextPacket() line: not available
DataPacket.receive() line: not available
DataPacket(Packet).receive() line: not available
SocketInputStream.read(byte[], int, int) line: 129
SocketInputStream.socketRead0(FileDescriptor, byte[], int, int,
int) line: not available [native method]
Any thoughts as to why it's performing so poorly? I'm using the
same connection style and performing the exact same query...
Thanks,
Ken
_______________________________________________
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/robertwalker1%
40mac.com
This email sent to [EMAIL PROTECTED]
--
Robert Walker
[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]
