Best data access method for SQL Server ?

rbuser

What is the best data access method to connect to SQL Server with RB ?
DBExpress, BDE, ADO ??? When I'm saying "best", I mean the best performance
for query execution and report generation. I have a complex huge report that
must render 600 pages in less than 30 seconds.

If you use DBExpress or ADO, tell me which drivers you're using and the used
parameters.

David

nardmoseley

I would use ADO. SQL Server and ADO are MS technologies. The Delphi ADO
components are wrappers around the MS ADO com libraries.

The SQL Server database engine is going to be responsible for building the
result set. You can time the performance of the query separately by creating
a timer and then setting ADOQuery to true. Then stop the timer on the next
statement.

The ADOQuery will retrieve the records from the SQL Server database. If
running on a separate machine, then a fast network will help.

You can perform a second benchmark, by writing a loop that traverses the
dataset from begin to end.

Those two benchmarks do not involve RB and therefore should provide a base
line of query execution and traversal time.



--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com