ADO vs DAO

[ibeevbee]

Generally question...

Is the ADO method of data-access significantly better than using DAO?

I'm about to rewrite a VB.Net data-application which I originally wrote using DAO, is it worth rewriting to use ADO?

Any views and experiences welcome!

[Athley]

If you consider how often DAO is used nowadays it kind of explains it self. I'm not saying that DAO does not have it's good sides, but yes, I would say that ADO is significantly better.

And that reply is relevant if you post the question in the VB6 forum as COM in itself is against the thougths of .NET framework creators.

/Leyan

[yolip]

sorry, i am wondering how better is ADO? in speed side? or something else?


regards,
Frankie

[ibeevbee]

Thanks for your replies, although I was thinking along the lines of Frankie.
Technological and flexibility improvements are good, but, speed is a good example of a difference that would warranty rewriting my code to use ADO. Is ADO faster, more efficient?

Regards,
Toby

[yolip]

I heard that long ago, DAO is faster then ADO, but due to it is more easy to use... .

is that correct?


thanks
Frankie

[Athley]

I think I can recall that I've heard that DAO should be faster in some areas as well. But I can't say anything for sure. A tip is to do 2 separate examples and benchmark it. That shouldn't be to hard. Something like....

Dim d1 As Date = Now
'ADO-code
MsgBox(Now.Subtract(d1).ToString)
Dim d2 As Date = Now
'DAO-code
MsgBox(Now.Subtract(d2).ToString)

/Leyan

[yolip]

thanks alot... i will try to work it out...