this ADO thing is SLOW! HELP!

[DrewDog_21]

I have a DBGrid and ADODC connected to an two tables on an Access DB on a Novell server. One table has about 10,000 records and the other around 150,000. Access can run the query in under a minute, but with ADODC the program appears to lock up and takes over five minutes to retrieve just 30-50 records.

I have seen other posts about similar problems but no one seems to know the solution. Has anyone a CLUE as to how to speed up ADO?

Thanks in advance,

Andrew

i can imagine, that you first testet with Access localy and then tried ADO via your LAN.

the problem is that Access is not a client-server database. it takes quite a while to download all the 150000 records over a newtwork to the client where they get queried, which will happen every time you run a query.

maybe you should try to port your database to SQL-Server or Oracle. in this case you send a sql-statement to the server, and get only the result back (be careful only to request exactly the amount of data required).

regards

[efrat]

Dont use data control

[Clunietp]

MS Access uses DAO to retrieve the data, which is much faster on Jet databases than ADO is.

The data control does not help, but the real killer is the network traffic you incur by pulling 150,000 records over the network, as Sascha mentioned

If you cannot convert to a real client/server database, you can create a database locally and link the tables on the network database. This will help somewhat, but when you have this many records, you really need a client/server database or use much smaller tables....

HTH

Tom

[Edited by Clunietp on 05-01-2000 at 10:54 PM]