Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: BLOB reading is slow
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.comReceived on Mon Nov 14 2005 - 23:13:07 CST
![]() |
![]() |