Re: Pros/Cons of ADO client-side cursors, Oracle 8i

I would tend to agree with Jim. Keep the Server Side cursors. I have investigated performance issues with respect to server side cursors in the past, and the main performance bottleneck appears to be at the client side. The performance varies with respect to the number of rows retrieved to the client and available memory of the client. My investigations found that performance was substantially increased until about 100 rows were retrieved, but after that performance degraded.

The environment was VB with Microsoft Driver for Oracle (ADO).

You really need to set up your own test to verify what is optimal for your situation

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:gYJMb.37948$sv6.111265_at_attbi_s52...
>
> "Julia Allen" <juliaallen_at_deltek.com> wrote in message
> news:20f13d823c1bd739bc506ee1bdee7341_at_news.teranews.com...
> > Hello,
> >
> > We have an Oracle VB application that uses ADO server-side cursors when
> > connecting to Oracle (adUseServer). In order to speed-up a performance
> > problem a client had with a batch module, we experimented with
client-side
> > cursors (adUseClient). It improved the performance of this module
> > tremendously. We now have to try and choose the best way to incorporate
> > this into our application without impacting other modules of the
> > application. The original developer of our db layer interface put in a
> > comment - something like "use Server side cursor to avoid ADO bugs with
> > client side Oracle cursors". The developer is no longer available and I
> > have no idea what kind-of bugs he encountered, or even what version of
> > Oracle (may have been Oracle 7).
> >
> > So, before we flip the switch to use client-side for our entire
> application,
> > can anyone think of problems we may have if we do or don't? Note,
again,
> it
> > is Oracle 8i, using Microsoft's oledb for Oracle (MSDAORA).
> >
> > Any helpful insights appreciated!
> >
> > Julia
> >
> >
> I would keep the server side cursor and find out what the performance
> problem was.
> Jim
>
>
Received on Tue Jan 13 2004 - 03:45:35 CST