Parameter on WHERE clause vs. Filter on returned data

  • Thread starter Thread starter Ardus Petus
  • Start date Start date
Ardus

Not sure what your question is...

From my point of view, limiting the number of returned rows (i.e., via
parameter) would reduce the network traffic compared to returning all rows,
then filtering.

Have you tried both approaches and timed them?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Using ADO, I need to return filtered data.
Click to expand...

If you passed the callee a filtered recordset they could apply another
Filter or remove your Filter.

Jamie.

--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where Clause with the OpenReport command 1
How do I write this: WHERE word LIKE '*' in ADO? 2
Access 2007 query (large IN statement), alternate approaches 8
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Using "like" query from and external link to Access 1
Query Parameter using multiple options 0
Cstr format 1
Code Snippet - Data Filter 8

Back
Top