ADO vs DAO

Is that true that DAO is faster then ADO VB6.0 when searching data because  we can search data using index? Is that true we can not use index when search data with ADO?
Sri HadijjoyoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
Hi,
Really the main factor should be depending on how you tune the queries, by adding proper indexes, and also the hardware configuration of your machines.
1
Éric MoreauSenior .Net ConsultantCommented:
should one really still use DAO today? this technology is VERY old and not supported anymore. You might also have issues with some datatypes of newer version of SQL server!
1
John Gates, CISSPSecurity ProfessionalCommented:
You should use ADO which will help you transition to ADO.NET when you upgrade your apps to .NET.

-D-
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

John Gates, CISSPSecurity ProfessionalCommented:
Oh and to answer the initial question ADO leverages all aspects of SQL server including indexes.

Hope this helps!
-D-
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Éric MoreauSenior .Net ConsultantCommented:
>>
will help you transition to ADO.NET when you upgrade your apps to .NET

Not sure it will help. ADO.Net is based DataSet which is completely new in .Net.
0
Sri HadijjoyoAuthor Commented:
I am newbie in VB. I try to learn from vb6.0 book (i think vb6.0 is an old release program so the book I read is an old book also I think). It is written in the book that DATA is faster ther ADO because we can use index with DATA. I really do not know which one is better or faster, that is why I am trying to get information whether or not ADO is not as faster as DATA to search evenhough ADO is a newer version than DATA. I am sorry if this question sounds silly. Thank you for your attention and regards.
0
Éric MoreauSenior .Net ConsultantCommented:
VB6 is from 1998. If you are serious about learning to program, you should learn something like VB.Net.

Also, you don't need to worry to much about indexes. When a query runs, SQL Server engine automatically picks the correct index whatever mechanism (DAO, ADO, ADO.Net, ...), you are using.
1
John Gates, CISSPSecurity ProfessionalCommented:
I would agree if you are just starting out I would stick to vb.net..  Having come from VB6 initially the transition to .NET was rough and if I were to start today it would be VB.NET / C# for sure!

-D-
1
Sri HadijjoyoAuthor Commented:
Is MS Visual Studio include VB.NET or VB like VB6.0?
0
Éric MoreauSenior .Net ConsultantCommented:
If you have a real visual studio and not just an Express edition targeting one very specific aspect, yes vs includes vb.net and c# and c++ and f#
1
Sri HadijjoyoAuthor Commented:
How I pronounce "C#" ? Thank you.
0
Éric MoreauSenior .Net ConsultantCommented:
C sharp
1
Sri HadijjoyoAuthor Commented:
@ Éric Moreau. Thank you for your information.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.