Re: Client performance.

Have you looked at the execution plans? Do they agree with what you expect?

I've found that when improperly tuned Oracle will not perform as well as SQL Server on the same box. When well tuned and with queries that effectively utilize the indexes Oracle performs better.

--
Michael D. Long
http://extremedna.homestead.com


"Marcus Hampel" <marcus.hampel_at_myview.de> wrote in message
news:394F809B.DBCC4A01_at_myview.de...


> 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