Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: BLOB reading is slow

Re: BLOB reading is slow

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 15 Nov 2005 05:13:07 GMT
Message-Id: <pan.2005.11.15.05.13.06.913706@sbcglobal.net>


On Mon, 14 Nov 2005 18:09:05 -0800, kuon wrote:

> Ho I did.
>
> But I read several documents, and according to them, SDU = MTU is the
> best value.
>
> I also tried a higher value,with absolutely no difference.
>

Kuon, forget about the SDU. It's baloney, delivered in his usual charming way. Look into the wait states, that is your best clue. You are waiting for the data FROM THE CLIENT. The delay is on the client side. You must find where is client spending the time. To do that, you should profile the client. There are many Java profilers which can help you there. I am not Java programmer, so I don't have any recommendations. If you are sending many small packets, then large SDU will only increase delays, as you will have to wait for the packets to fill. Increasing SDU on Sybrand's advice is suicidal. Reading Sybrand's replies is sheer fun, but you shouldn't follow his advice.

-- 
http://www.mgogala.com
Received on Mon Nov 14 2005 - 23:13:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US