DAO Performance

[mhowarth]

I am comparing 2 databases with approx. 60000 and 20000 records respectively.

I wish to find matches within fields in either db.

Which would be quicker - building to arrays or using dao.

Thanks.

 

[Zion7]

Recordsets of course.
ADO is my choice of language, for most recordset searching & manipulation (as opposed to DAO).

But maybe a query might give you quicker results?

Create a union query and analyse...

"SELECT DISTINCT..."
OR
"...HAVING COUNT(txtField) > 1

 

[mhowarth]

Thanks Zion7

What is the advantage of using ADO over DAO - one of the the dbs is MSAccess so DAO seemed the natural one to use. Is ADO quicker or is it just a personal preference.

 

[Zion7]

No performance benefits but, it's the latest microsoft language for connectivity, primarily.
All further research & development is done in ADO.
DAO will no longer be developed by MS.
In some cases DAO, is richer in features, but for most recordset manipulation, ADO is sufficient.

I'd recommend all developpers new to either language, to concetrate on ADO, since DAO will soon become "unnecessary", and possibly obsolete.

 

[mhowarth]

I have had a quick look at ado and also the union queries and it seems the query approach is quickest.

Thanks again for pointing me in the right direction.