[All]
Improving the response time of ADO MS Access Queries
Abstract: Improving the response time of ADO MS Access Queries
Problem Description:
When performing a select statement against an MS Access table using a TADOQuery component, the time to open the query is long when there are a large number rows to return
Problem Resolution:
The reason for this is that the component will fetch back all rows before displaying them. The time to open can be decreased by setting the component?s CursorLocation property to clUseServer.
