Re: improve performance thru oracle odbc driver

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: Fri, 12 Nov 1999 09:43:43 +0000
Message-ID: <382BE14F.1A74FC3C@totalise.co.uk>

screwbai_at_my-deja.com wrote:
>
> I have a borland client application using an oracle odbc driver against
> oracle 7.3.4 over a WAN. It's performance is not good.
>
> Any hot tuning tips.
>
> I have one theory that I can can improve performance over a WAN by using
> the highest possible packet size. We currently get an averages packet
> size with send/rec of 270b. Recive we have 400b. Any views on improving
> this if it matters.
>
> All other tips appreciated as well.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

HI
I presume you've tuned the application and queries it's executing and then the DB itself. It may be that the WAN is not the problem - or does it run fine over the LAN and not the WAN?

martin Received on Fri Nov 12 1999 - 03:43:43 CST