Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DAO and ADO features
- Thread starter onana
- Start date
Karl Blessing
Programmer
I'll put it in simple terms
DAO - singlethreaded - only one connection at a time - sometimes faster than ADO
ADO - multithreaded - can handle multiple connections - pretty fast for SQL and what not if you write it efficiently
big advantage for DAO is that if you use it in an application, where it is the only connection being made to a data base (such as a Utility saving it's settings to a database using DAO) it's rather fast.
big advantage of ADO, ADO is very useful with dealing with applications that require multiple connections, for example A serverside webapplication may load several peices of data from a database using multiple recordsets on a single connection, but then you would need to allow multiple instances for every connection made from the number of visitors to the site.
Karl
kb244@kb244.com
Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)
DAO - singlethreaded - only one connection at a time - sometimes faster than ADO
ADO - multithreaded - can handle multiple connections - pretty fast for SQL and what not if you write it efficiently
big advantage for DAO is that if you use it in an application, where it is the only connection being made to a data base (such as a Utility saving it's settings to a database using DAO) it's rather fast.
big advantage of ADO, ADO is very useful with dealing with applications that require multiple connections, for example A serverside webapplication may load several peices of data from a database using multiple recordsets on a single connection, but then you would need to allow multiple instances for every connection made from the number of visitors to the site.
Karl
kb244@kb244.com
Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)
I personally find DAO a lot more straightforward and easier to use for manipulating data in different ways. Like when several calculations need to be made on different recordsets and SQL wont cut it, or it would just be too complicated, I find DAO very useful for this.
- Status
Similar threads
