sqldatareader compare to server side read only cursor in ado

From: z f (zigi_at_info-scope.co.il)
Date: 09/06/04 

Date: Mon, 6 Sep 2004 06:58:04 +0200

Hi,

SqlDataReader must be connected to the database in order to bring data.
this is like server side cursor read only in ado.

the point is that in the SQL Profiler, when my code is running over the
records in ado recordset with server side cursor, i see SQL activity for
each move in the record.
in SqlDataReader i don't see the same activity in the profiler for each
record.

can someone explane why is the difference and is the DataReader really a
server side cursor?

TIA, z.

Relevant Pages

  • Re: ADO Data Control Concurrency Problem
    ... >> Editing of row in table is done with the help of ADO Data Control. ... Cursor location does not bare on whether the ... Client or Server memory. ... reflected in the open recordset. ...
    (microsoft.public.vb.general.discussion)
  • Re: Client Cursor oder Server Cursor?
    ... > Summa summarum dürfte es jemanden, der seine Programmierung auf ADO die ... So erstellt der SQL Server ein internes ... > Während der Client Cursor für den Abruf ein ForwardOnly/ReadOnly ...
    (microsoft.public.de.sqlserver)
  • Re: Didnt ADO used to default to client-side cursors?
    ... > The Execute takes a bit longer, but the client-side cursor is quite a ... set on the server in order to create a local ADO result set. ... ADO had more round trips to complete. ... asynchronous load for the client cursor. ...
    (microsoft.public.sqlserver.server)
  • Re: Didnt ADO used to default to client-side cursors?
    ... > The Execute takes a bit longer, but the client-side cursor is quite a ... set on the server in order to create a local ADO result set. ... ADO had more round trips to complete. ... asynchronous load for the client cursor. ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Server extremely slow
    ... terms of what is meant by a dis-connected ado recordset. ... table in a mdb file could be considered disconnected from the server ... Well, ok, but keep in mind the disk drive is on sql server! ... 10 reocrds from the server via odbc does not produce more ...
    (comp.databases.ms-access)