Re: Client performance.

Hello.

Niall Litchfield wrote:
>
> couple of things that might be worth looking at
>
> 1) Try changing the ODBC driver - in general the ms ones are better > but
> sometimes you get better results with Oracle provided drivers.
We have also created an OCI driver for a Linux version. Exactly the same problem. I have also tried third party products => All solutions doesn't provide important performance improvements (max. 10-20%).

> 2) Is the code for Oracle/SQLServer working in *exactly* the same way
Exactly the same way. Only the data souce changed.

>(some
> code snippets might be useful).

Which of the 150 statemant does you want to see :X)

> In particular opening a connection to
> a database is an expensive operation , but reusing an open
> connection object is fast.

Ok, this is true. It take 0.25s on Oracle. But where is the rest of the 4s? And why does the client gets such hight CPU load? It's not the application itself.

Thanks,

        Marcus Received on Tue Jun 20 2000 - 00:00:00 CDT