Accessing A Large MS SQL Table Over ADO Components

deliMawi
Date: 10/10/04 

Date: Sun, 10 Oct 2004 11:40:59 +0300

Hi all again,

We will be developing a large database application and currently we are
working on some base forms and planning the architecthture.

An avarage table will be holding around 1000000 records in our application.

If we want to display the data on a readonly grid wich component is the best
to use, TADODataSet or TADOQuery ?
What about if the grid is not readonly?
And I want to know, if I use a standart DB Grid, does the dataset component
fetches all the records to client?
What about the cursor location. Setting the cursor to serverside has any
advantages? Because I had some performance loss when I set it up to Server
Side?
And also ADO Components are a good choice?

Could you please forward me some links or docs about Delphi + ADO + SQL
Server Performance issues?

Thanks in advance
deliMawi

Relevant Pages

  • Oracle - solving performance problem
    ... I inherited the following server and problem. ... has its own SCSI channel. ... - Increase SGA to 2.7, jump to 3.7 not done yet. ... - Scrap SCSI and use a fiber channel SAN instead, in standalone or Grid ...
    (comp.databases.oracle.server)
  • Re: How to fire an event
    ... The button click event is being raised upon a post-back to the server. ... The problem here is that I have no idea whether the grid will raise the ... void gd_UpdateRowBatch ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Accessing A Large MS SQL Table Over ADO Components
    ... I do not want to fecth all the records to the grid. ... I do not want to slow down the server using server-side ... >> What about the cursor location. ... > Server-side cursor does not fetch all rows to client, ...
    (borland.public.delphi.database.ado)
  • Re: Zugriff sehr langsam (Bingo! Jetzt gehts schneller!)
    ... es ist ein ADODC and dem ein Grid gebunden ist. ... Eine Zuweisung ... >> Dann muss es irgendetwas auf diesem Server geben, ...
    (microsoft.public.de.vb.datenbank)
  • Re: ADO, ODBC, Service process
    ... > is located on a file server. ... if you are using the ADO components, i would rather suggest you to use the ... OLE DB provider contained in Microsoft's Jet 4.0, than using the ODBC. ... distributed with Microsoft's desktop databases. ...
    (borland.public.delphi.database.ado)