Re: BLOB reading is slow

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 15 Nov 2005 04:56:03 GMT
Message-Id: <pan.2005.11.15.04.56.02.783144@sbcglobal.net>

On Mon, 14 Nov 2005 11:09:19 -0800, kuon wrote:

> I hope this data will speak more:
>
> *** 2005-11-14 20:05:04.492
> WAIT #0: nam='SQL*Net message from client' ela= 8006447 driver

This speaks volumes. Given that the time is expressed in microseconds, your wait for data from client is 8 seconds. All other waits are in tens of microseconds. So, you checked the network, it's OK, you checked the database, its OK. That leaves us the client as the only remaining culprit. Profile the client and see where the time is spent. Then figure out how to rewrite the routine that causes such delays. Alternatively, get your boss to buy you much faster PC and rewrite the client. Faster PC is usually better for playing games. Make sure that it has a video card with at least 128MB memory of RAM, OpenGL and anti-aliasing implemented in hardware. I hear that NVIDIA 7800 with 256MB is pretty decent. It makes unspeakable abominations run much faster.

-- 
http://www.mgogala.com

Received on Mon Nov 14 2005 - 22:56:03 CST