Solved

SQL View - PT vs. Table Link

Posted on 2007-03-30
4
212 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:adraughn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 18823548
I can't think of any others. Either way the query/view should be executed server side.
0
 
LVL 13

Author Comment

by:adraughn
ID: 18823656
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
 
LVL 38

Accepted Solution

by:
Jim P. earned 500 total points
ID: 18824020
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
 
LVL 38

Expert Comment

by:Jim P.
ID: 18824082
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question