view or pass-through

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any performance benefit to using a SQL view over an Access
pass-through query when using SQL server as the backend?
 
I think the most efficient would be for the pass-through query to call the
SQL view.
 
The main benefit you get by using sql view over pass thrugh is that you can
use the view with the stored procedure you will write in the sql server,
other wise it works the same. a pass-through query performance is just like a
view, that the point of it, it will do the process in the server instead of
the working station, but you cant use the pass-through query in the stored
procedures.
 
Also incase you need to use that query/view from fiew places then it better
to create a view, that way you need to maintain it once, in one place with
link to all the db used, that way if you need to change it you don't have to
change it in all the db.
 
Back
Top