SQL View - PT vs. Table Link

Access 97/2k,2k7, SQL 2k5
I currently have SQL views linked as tables in my access db. Are there any benefits to changing it from a link to the view to a pass through query executing the view? (Besides the con of the PT being read-only)

-adria
LVL 13
adraughnAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jim P.Connect With a Mentor Commented:
The only work client side using the view is the Order By or if you put further where clauses on the view when you open it.

If you have a view on the server such as IS_Emp_Vw:
SELECT *
FROM EMPLOYEE_TABLE
WHERE Active = 1
AND Dept = 1357

and link it to an Acc DB as a table all the work is done on the server. Now, if you link it as a table an then do a query against it as
SELECT *
FROM dbo_IS_Emp_Vw
WHERE Emp_Name like "P*"
The where clause is does client side, but the rest is done server side. The PT just makes the Emp_name clause server side as well.
0
 
Jim P.Commented:
I can't think of any others. Either way the query/view should be executed server side.
0
 
adraughnAuthor Commented:
so right now i just have my view linked as a table to access. so all of the work of creating the view is on the server. i just thought that if i changed it to a PT query in access, since it does not use jet at all with the PT, that there may possibly be a performance increase.

thoughts?
0
 
Jim P.Commented:
Glad to be of assistance. May all your days get brighter and brighter.
0
All Courses

From novice to tech pro — start learning today.