Information générale
Catégorie:
COM/DCOM et OLE Automation
>I have found a speed issue when using DAO recordsets.
>
>I am getting exactly the same data from VFP and SQL yet, when I get the data from SQL, looping through the resulting recordset is vastly slower.
>
>To check this, I tried exactly the same thing in VBA (Excel) and had exactly the same speed issue - worked very fast if data came from VFP but very slow if data came from SQL (also, I couldn't put native values into worksheet cells if data came from SQL).
>
>Does anybody have any ideas on this? It needs to be DAO as this is working with Excel 97 and Windows 95 (client has many offices and is using this software around the country).
>
>TIA,
You might get better performance with a snapshot-type recordset, assuming you don't need to modify it.
The other option is to use ADO and the OLEDB provider for SQL. The data access concepts are largely the same as in DAO.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement