-
I have a Access Database with 1 millon of records and it have 460 Mb.
1) In one project I have a dao control conect to a datagrid.
The source of dao control have a SQL like select * from table where (yearmonth = 200001).
When I run the aplication, I have a fast response from the database. The response is immediately
2) If I use a ADO control conect to a datagrid, with the same SQL, the aplication have a big delay (1 or 2 minutes)depending of the SQL.
I change some parameters from the conection of the ADO but never have a fast response from the database like a DAO control
Any Idea???
-
What open mode are you using for the ADO query?
-
I create a environment, use a connection with microsoft jet 4.0 OLE DB Provider.
After that I create a command with a SQL command.
In the advance parameter I use a Recordset and a cursor over the client
-
Try using a server-side cursor.
-
With server-side cursor.
Using a server-side cursor I dont obtain any records.
When use a server-side cursor, the data grid appear in blank
Julián
-
Is the database on some machine other than yours? If so you could try making a database that has links to the one with data and open the one that contains the links...