ADO slower than ODBC?
Posted on 2003-02-19
In my Delphi 6 app, I am accessing a table on a MS SQL server with a little over 1 million records (Stock transactions). When I access it with ADO (tAdoQuery) with Cursorlocation = clUseClient it takes forever to open the dataset, and I need to use clUseClient in order to browse the dataset.
If I access the table through an ODBC datasource using TQuery it is a least 10 times faster to open the table and I can still browse the dataset.
I want to use ADO because it is easier to distribute, but how do I speed it up?
Thanks in advance