General information
Category:
COM/DCOM and 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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only