Fastest connection ? - BDE/ODBC/ADO

[Karen99]

First by your opinion is the fastest connection from Delphi 5 to Sql Server 2000 :

BDE
ODBC
ADO ?

 

[hilfy]

I don't know which is faster (probably ADO), but I do know that the BDE does not let you use all of the field types that are available in SQL Server 2000. This is not Borland's fault, but Microsoft's for not updating the drivers that the BDE uses because they want developers to move to ADO.

-D

 

[bbegley]

We have found that ADO is much faster than for Access, but we haven't tested SQL very much.

Brian
"There are 2 kinds of people in the world, those that divide people into two groups and those that don't. I belong to the second group." - tag line I stole

 

[svanels]

Depends on how you are using the database components. Desktop systems are complete different animals compared to Client-Server database systems.

Steven van Els
SAvanEls@cq-link.sr

 

[Karen99]

Any opinions about DBExpress ?

 

[VintageWine]

I have used BDE and ADO, both with "native" drivers and ODBC. To be honest I have found no noticeable speed difference as the real work is done inside SQL Server and in ClientDataSets. These above technologies are just conduits.

What I have found is that ADO is easiest to configure, distribute and use. It also handles the greatest variety of SQL Server features.

I believe that the dbExpress for SQL Server is an ADO wrapper (anyone confirm/deny?).

Have fun
Simon