ADO的速度究竟怎么样？和ODBC，DAO比起来？回答完整的给高分，欢迎大家调查，研究
书上说ADO快，并不可信
我试过DAO最快，直接使用DAO最快，ODBC确实比较慢
但是我不清楚ADO的速度
请大家调查，研究，谢谢
问题点数：200、回复次数：7Top
1 楼fly_pig（易飞扬）回复于 2001-11-11 23:15:48 得分 0
careTop
2 楼sky100（大海边的沙滩上捡贝壳的孩子）回复于 2001-11-11 23:23:48 得分 0
如果是微软的数据库（如access,sql server)则dao最快Top
3 楼karma（无为MS MVP）回复于 2001-11-11 23:28:23 得分 100
ODBC is irrelevant here
here is a reply from Microsoft on the topic of "What is Better ADO or DAO ? "
http://groups.google.com/groups?hl=en&selm=ORHJpVQUBHA.301%40cppssbbsa01.microsoft.com
"Carlos,
In the majority of situations ADO will be significantly superior to DAO in
terms of performance, reliability, scalability, and compatibility. DAO is
no longer being developed by Microsoft so there will be no new updates or
features added to it. ADO is the future of data access so you will be much
better off learning and using ADO. If you do a search for "ado dao
performance" (without the quotes) in the MSDN library you will find a
number of articles detailing the differences.
Kevin Williamson - Microsoft Visual Basic Developer Support
"
As for some benchmarking, read this thread (note, it was done in 1998)
http://groups.google.com/groups?hl=en&threadm=u3I%24EMhl9GA.262%40uppssnewspub04.moswest.msn.net&rnum=1&prev=/groups%3Fq%3Dperformance%2Bado%2Bdao%26hl%3Den%26rnum%3D1%26selm%3Du3I%2524EMhl9GA.262%2540uppssnewspub04.moswest.msn.net
ADO 1.5 vs DAO 3.5
#Loops ADO DAO
1 405 236 ms
10 4,037 2,545 ms
100 40,182 24,915 ms
Top
4 楼backspace（backspace）回复于 2001-11-11 23:38:14 得分 100
Just a hint. I read this in some newsgroups. ADO+VB has better performance than ADO+VC, since ADO has been optimized internally for VB. If you use VC, then OLEDB may be a better choice.Top
5 楼wyzegg（蛋）回复于 2001-11-12 00:51:25 得分 0
ADO使用时和驱动程序相关，就对于JET数据库来说，速度不如DAO，但是ADO使用了连接池，多客户的访问的性能会有优势的
Top
6 楼coolarcher（冷箭手.风雨如晦，鸡鸣不已.既见君子，云胡不喜?）回复于 2001-11-12 03:24:09 得分 0
VB用ADO的确蛮快的……
VC速度一般吧……当然还要看数据库。Top
7 楼xtky_limi（窗外细雨）回复于 2001-12-25 15:56:50 得分 0
listenTop
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
