Re: BLOB reading is slow

Tnsping for test client machine.

goyman_at_fulgore:~$ tnsping nadesico

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 14-NOV-2005 18:02:10 Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/home/goyman/oracle/product/10.2.0/client_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=nadesico.goyman.com))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.6)(PORT=1521))) OK (0 msec)

DNS are fine, I checked them. (both reverse and straight)

I also checked getBufferSize and getChunkSize in JDBC, I have adjusted my own buffer to match them, but without any change.

Anyway, what I don't really understand is why writing is fast (about 1mb per second, 1/50 ftp performances for the same transfer, but enough for my application), but reading has those strange hang. That's why I think it's not a network problem.

I also just begun to write a debug application in C, with oci, I'll let you know the results. Received on Mon Nov 14 2005 - 11:22:45 CST