Question about pass through queries

  • Thread starter Thread starter Bongard
  • Start date Start date
B

Bongard

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!
 
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.
 
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!
 
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.
 
Back
Top