Thanks - it really doesn't make any sense... I was hoping someone
came across some weird way that WO was configuring the connection or
something.
On May 15, 2007, at 3:51 PM, Robert Walker wrote:
Ken,
Interesting. We also use the "thin" driver for Oracle and don't
seem to be having this trouble. We are using version 14 of the
JDBC driver I think.
You've exhausted my ideas on what the problem might be. Wish I
could help further.
On May 15, 2007, at 2:57 PM, Ken Anderson wrote:
Robert,
It spends the entire time at the socket read. The query is only
returning 43 rows...
Ken
On May 15, 2007, at 2:53 PM, Robert Walker wrote:
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/kenlists%
40anderhome.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/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]
