If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Question about pass through queries
I have a large database where I am contemplating using pass-through
queries to all my ODBC tables or just bringing in all the linked tables and running queries from the tables. What I am most concerned with is which method will have better performance? Will it make a difference? Thanks! |
#2
|
|||
|
|||
Question about pass through queries
Performance should be much improved with P-T queries. Keep in mind, your P-T
records will not be updateable and the SQL must match your database server syntax. You also can't join to a local table within the P-T. -- Duane Hookom Microsoft Access MVP "Bongard" wrote: I have a large database where I am contemplating using pass-through queries to all my ODBC tables or just bringing in all the linked tables and running queries from the tables. What I am most concerned with is which method will have better performance? Will it make a difference? Thanks! |
#3
|
|||
|
|||
Question about pass through queries
Thanks much Duane! The reason I asked is because it felt like a few of
my basic pass-through queries were running slower than the queries based off the linked tables and I didn't know whether I should go back to linked tables or not. Thanks for your help! |
#4
|
|||
|
|||
Question about pass through queries
It's always been my experience that P-T queries are more efficient. It might
be an issue where you have a criteria in the linked table query and no filtering on the P-T. -- Duane Hookom Microsoft Access MVP "Bongard" wrote: Thanks much Duane! The reason I asked is because it felt like a few of my basic pass-through queries were running slower than the queries based off the linked tables and I didn't know whether I should go back to linked tables or not. Thanks for your help! |
Thread Tools | |
Display Modes | |
|
|