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/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
