Very Computer

Why the same form take 15 times more to open with the ADO's data control
then with DAO's control. I open a form with 13 ADOs on it, in 22 secondes
and with replacing ADO by DAO control it came back to 1 to 2 second, same
thing with a querry very slow with ADO and very fast with DAO.
Any ideas?

It depends on several factors, generally ADO is much more better that DAO in
the sense of speed and functionalities. You have to consider the environment
like the type of database, using Jet or SQL server, client or server
environment, your recordset cursor moving method and also your programming
method against the ADO cursor.

--

Regards,

David Voo

Quote:> Why the same form take 15 times more to open with the ADO's data control
> then with DAO's control. I open a form with 13 ADOs on it, in 22 secondes
> and with replacing ADO by DAO control it came back to 1 to 2 second, same
> thing with a querry very slow with ADO and very fast with DAO.
> Any ideas?

Yves,

Try to change CursorLocation property of ADODC. By default ADO uses
client-side cursors and data are copied to RAM. DAO (as far as I remember)
has server-side cursors only, i.e. it retrieves data from db into memory as
needed when you move through recordset. That means that for ADO with
client-side cursor it takes more time to open the rs but it moves through
records faster, because all data is in memory already. Try this with both
data controls: open the form and move to the last record. Time required
should be almost the same .

--
HTH,
Alexander Shirshov, MCSD

Quote:> Why the same form take 15 times more to open with the ADO's data control
> then with DAO's control. I open a form with 13 ADOs on it, in 22 secondes
> and with replacing ADO by DAO control it came back to 1 to 2 second, same
> thing with a querry very slow with ADO and very fast with DAO.
> Any ideas?

Quote:>By default ADO uses client-side cursors

No it uses Server Side cursors by default

Quote:>DAO (as far as I remember)
> has server-side cursors only

No client side cursors

Adam
* Keep up-to-date by attending the monthly meetings at the 'Access/SQL
Server/ASP.Net User Group, Sydney"   www.ssw.com.au/AccessUG
--------------------------------------------------------
Check out these HOT UTILITIES FOR ACCESS AND VB DEVELOPERS....
www.ssw.com.au
* SSW Data PRO  - Version Control for your data.mdb
* SSW Data Renovator  - Compare the differences between two data.mdb's
* SSW Upsize PRO! - Don't UPSIZE to SQL Server without it
* SSW SQL Script Wizard - A utility to run .sql files
* SSW Performance PRO! - Find out what is slow in your Access App
--------------------------------------------------------

Quote:> >By default ADO uses client-side cursors

> No it uses Server Side cursors by default

I meant ADODC, sorry