TDataSetProvider: to use or not to use?

I am acessing a SQL Server 2000 Database with Delphi 7. Some of the tables
to be read have few lines of data while others have more than 300,000
registers. A two layer system architecture is being used.

I have come through a couple of ways of retrieving this information:

1st TADODataSet (CursorType = ctOpenForwardOnly; CursorLocation =
clUseServer)
TDataSetProvider;
TClientDataSet;
TDataSource

or

2nd TADODataSet (CursorType = ctStatic; CursorLocation = clUseClient)
TDataSource

Which benefits each approach will give me? Is there a standard solution?
Which
alternative consumes less resources from the SQL Server?

Emile Petrus Abi-Abib


.

Relevant Pages

  • Re: D2007 - No Way. No How.
    ... the big risk, really? ... It really depends on what you're doing with Delphi, ... database, i.e. must be up 99.999% of the time, you choose Delphi, (an ... FirebirdSQL and MS SQL Server! ...
    (borland.public.delphi.non-technical)
  • Cant connect to SQL Server 2000 with Visual Studio 2005
    ... I've been using Delphi for years and connecting to my SQL Server ... However, when I try to select a database name, the dropdown is never ...
    (microsoft.public.sqlserver.connect)
  • DELPHI 7 & DB2?
    ... I Would like to develop a system for a costumer wich owns Delphi 7,but its hard to find a database. ... Sql Server 2000 is not serious,It does not let me have two foreign keys related to the same table. ...
    (borland.public.delphi.thirdpartytools.general)
  • Save Pdf to database
    ... Anyone knows if there's a way to save and load Pdf documents to a SQL Server ... database using Delphi? ...
    (borland.public.delphi.database.ado)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)