Re: Didn't ADO used to default to client-side cursors?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: jxstern (jxstern_at_nowhere.com)
Date: 12/02/04 

Date: Thu, 02 Dec 2004 15:49:40 -0800

On Thu, 2 Dec 2004 15:26:17 -0500, "David Gugick"
<davidg-nospam@imceda.com> wrote:
> Have you noticed whether the
>application performs a little slower using the client-side cursor?

A bit faster, actually.

The Execute takes a bit longer, but the client-side cursor is quite a
bit faster than the server-side, which only makes sense since it
doesn't have to reach across the network.

J.

Relevant Pages

  • Re: Didnt ADO used to default to client-side cursors?
    ... >application performs a little slower using the client-side cursor? ... The Execute takes a bit longer, but the client-side cursor is quite a ... doesn't have to reach across the network. ...
    (microsoft.public.sqlserver.server)
  • Re: XML ODBC Driver?
    ... Configure the ADO connection for a client-side cursor, execute the SQL ...
    (borland.public.delphi.non-technical)