| 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
|