I'm doing a project in which I need to work with very large recordsets. I need to test the value of a field in the recordset. So I'm going to use a query. So far so good, but I really want to minimize network traffic and resources, so which is better?
1. A parameter Select Query with the TOP Property set to 1, or
2. A parameter Aggregate Query with the Count on the Primary Key?
So in the Aggregate query does Access have to bring over all the records in the recordset (not very efficient)? To retrieve the TOP 1 record, does it need to bring over all the records?
All defensive answers (like you have run the benchmark already) are welcome. Gut Feel responses on this probably will not be very helpful.
Thanks in advance for your help.
1. A parameter Select Query with the TOP Property set to 1, or
2. A parameter Aggregate Query with the Count on the Primary Key?
So in the Aggregate query does Access have to bring over all the records in the recordset (not very efficient)? To retrieve the TOP 1 record, does it need to bring over all the records?
All defensive answers (like you have run the benchmark already) are welcome. Gut Feel responses on this probably will not be very helpful.
Thanks in advance for your help.
