Re: BLOB reading is slow

On Sat, 12 Nov 2005 17:33:41 -0800, kuon wrote:

> Hello,
>
> I'm currently developing a JDBC program on Oracle and I have the
> following problem.
>
> I use the BLOB.getBinaryStream() method, it works fine, I got the
> stream and I can read it.
>
> My problem is slow performances, when I call stream.read():
>
> The first call takes 10 seconds.
> Then 32*1024 next calls are very fast.
> Then hang for 10 seconds
> Then 32ko readed fast, hang....
>
> Do you have any idea if this is Database or JDBC problem?
>
> The network is fine.
>
> I think it's a SQL Net problem, because when I SQL plus to the db on
> the local computer, the connection is immediate, but if I sqlPlus from
> remote computer, the connection hang for 5 seconds before showing me
> the sqlPlus prompt. And 32ko seems to be the net packet size, but I'm
> not sure of this.

On the oracle-l, where you cross posted the problem, I asked you about the wait in V$SESSION_WAIT and V$SESSION_EVENT. Any news or are you cross posting just to annoy the heck out of me?

-- 
http://www.mgogala.com