SLOW ADO

[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

[WadeD]

Is Access running under a minute if you run it from the client-side or the server? If you're issuing a SQL statement in VB from the client-side, all 150,000+ records are being returned to the client where the filtering occurs. If you were in SQL Server, you could use a Stored Procedure to do the filtering on the server. In Access, you maybe could use a parameter query. You need something to do the bulk of that processing on the server where you have greater resources.

[DrewDog_21]

Hi Wade, thanks for the tips. Being inexperienced with stored procedures, do you know of anywhere where I could find an example of using one to connect to an Access DB from the client side in VB? I've changed the code around and cut the hang time down, but it still locks for 2-3 minutes.