Re: Client performance.

"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)

Ouch - I take your point though. It would definitely be worth having a look at the performance of the queries though. I realize this will not be fun.

One further thing from rereading your original post.

I notice you have USE_PLUG_AND_PLAY_LISTENER=TRUE, suggesting that you are using Oracle Names - however you seem to be using tried & trusted TNSNAMES as a name resolution method. It might be worth disabling the use of Oracle Names see if the name lookup is causing a problem - I have known this happen, not often admittedly.

Mind you you could always admit defeat and go with SQL Server :-(

--
Niall Litchfield
Oracle DBA
Audit Commission UK