Performance MS-SQL + clUseServer + ctKeyset

From: Bernhard Geyer (Bernhard.Geyer_at_nospam.com)
Date: 07/08/04

  • Next message: Del Murray: "Re: How to know when a register is being modified?" 
    Date: Thu, 8 Jul 2004 14:39:39 +0200

    I want to open a large table (select * from mytable) in a MS-SQL-Database
    with TADODataset an display the content in a DBGrid.

    When Using clUseServer + ctKeyset (ctKeyset is needed for Grid), the opening
    of the query
    take a long time. The same problem is when try to use the ADO-Components
    direct.

    When trying the same with BDE + ODBC and TQuery, the opening of the query
    take only a few msecs.

    Are the any optimizations to open a serverside-curser with ADO and binding
    to a grid?

    Best regards

    Bernhard

  • Next message: Del Murray: "Re: How to know when a register is being modified?"

    Relevant Pages

    • Re: update query: still having problems
      ... bring the workstatus field in the grid and, at the criteria line, write: ... UPDATE Department INNER JOIN Sheet1 ON Department.employeeID = ... What I want to do is press a button that will run the query and update the ...
      (microsoft.public.access.queries)
    • Re: Sequence numbering labels
      ... The upper pane of the query design window contains the tables. ... lower pane is the output grid. ... table field to the query output grid' ...that I did not understand, ... and put that count field into the label via label wizard. ...
      (microsoft.public.access.modulesdaovba)
    • Re: VB.NET - How do I return an AutoNumber from an Insert Statement using the DataGridView
      ... > Thanks for that Bart, ... > the values from my Grid to the TableAdapters Insert method. ... >> choose add query, then choose insert query, use a query like below, ... >>> stored in the SQL Database but a VB generated (or disconected dataset ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Using queries in a table adaptor?
      ... using the query wizard I have added several queries ... FROM [Drive Package] ... Not there is no Join here these are just simple Queries on a simple table. ... I am use the flex grid because of some unique features ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: timeline/calendar datagrid
      ... MS Access MVP ... query via code --the query would create a temp table then populate the ... month/year across the top and a grid for each week within each month. ... i'm not interested in the color, etc of the screenshot. ...
      (microsoft.public.access.forms)