Re: Performance using adOpenKeyset and adUseServer

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 07/08/04

  • Next message: Mike: "Problem with FOR XML EXPLICIT query with Execute XmlReader" 
    Date: Thu, 8 Jul 2004 09:49:55 -0700

    In the ODBC case, no cursor is being built. This command returns the first
    few rows immediately and uses a stream to return the remaining rows. In the
    ADO case, a server-side cursor is created along with support structures on
    the client. 

    -- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Bernhard Geyer" <Bernhard.Geyer@nospam.com> wrote in message
news:e$KlFgOZEHA.3368@TK2MSFTNGP12.phx.gbl...
> I'm trying to open a Recordset with adOpenKeyset and adUseServer (select *
> from mytable) (I need adOpenKeyset, because I
> bind the Recordset to a Grid using Delphi and dbGo-Wrapper around
> ADO-Components).
>
> But with this settings (adOpenKeyset and adUseServer), the opening of the
> recordset take a long time, when
> the command is executed.
>
> When using ODBC (with BDE), this command opens very fast.
>
>
> When profiling with SQL-Profiler, I found following difference.
>
> Opening with ODBC, only the Entry "select * from mytable"
>
> when opening with ADO, there is a curser open with "exec sp_cursoropen @P1
> output, N'select * from mytable', @P2 output, @P3 output, @P4 output ...
> and this curser-opening takes a long time...
>
> Which settings allows me to open my table with Server-Curser and
Bindability
> to a grid?
>
> Thanks for any hints
>
> Bernhard
>
>
  • Next message: Mike: "Problem with FOR XML EXPLICIT query with Execute XmlReader"

    Relevant Pages

    • Re: opening tex file from terminal
      ... Do anybody can suggest me the proper command line? ... gedit works fine for me. ... Please note that the fact that the cursor is ... command line _AND_ opens the document. ...
      (comp.text.tex)
    • RE: Search Box
      ... I want to include a command button that opens the ... regardless of where the cursor might ...
      (microsoft.public.access.forms)
    • Right-Click Context Menu Question
      ... command. ... an arrow pointing to the right with that opens the list if the cursor is ...
      (microsoft.public.windowsxp.help_and_support)
    • Re: VFP Updates?
      ... Try talking ODBC or OleDb and they say HU. ... make up my apps so that what ever they want to run has to be from a command ... kind of connection and assign it the right to do exactly what you want. ...
      (microsoft.public.fox.programmer.exchange)
    • Re: Ms Scanner @ Camera Wizard - What is it ?
      ... Type into the Run command and see what opens: ... You can open almost anything with the Run command. ... You can open a file or folder or connect to a shared computer by typing ... Right click Shared Documents and click Properties. ...
      (microsoft.public.windowsxp.general)