SQL query

[Sam]

I am looking to minimize network traffic with SQL 2008 backend. I have 22,000
clients in a table and want to select a small filtered list (less than 50).

My options are to:
1) execute a select query against a passthrough query that holds all records,
2) execute a direct SQL statement from vba code to a view in SQL 2008
3) write the entire statement on the Access side and execute from code
(DoCmd.RunSQL)

The reason for the view or passthrough is that there are a couple of tables
joined and some formatting.

Which options is fastest with least network traffic? This routine serves for
general client lookup, so very high traffic.

 

[Jerry Whittle]

1 and 2 together. Create a view and run a pass-thru against it. You could use
the view to gather up all the needed records and the pass-thru if you need to
drill down further or have different criteria at times.