Hello,

I am using ADO to read and write data in Access and SQL-Server databases. The user can select the type of the database that he wants to use. That all works perfectly, but I have a strange performance problem when I read large amounts of data from a table. To be specific, in this case I only read values coming from one field but in 10.000 records. So basicly I only have

Code:
m_pRecordset->Fields->GetItem(0)->Value;
//and
m_pRecordset->MoveNext();
While that takes around 3 seconds for Access, SQL Server needs more than 10 seconds for all 10k records. In my test scenario the server is installed on my computer.

Is there anything I can do to make things faster?

Best regards,
Robin