Re: ODBC linked tables vs. SQL specific passthrough

Tech-Archive recommends: Speed Up your PC by fixing your registry

Yes it is true. I have found that running pass-through queries speed
up the process significantly. For example, one query I was using took
about 30 seconds to run when using the ODBC linked tables and running a
query on them. When I used a pass-through query instead, it took about
2 seconds. The way I understand it is Access goes out to the server
and grabs the entire table you are querying on and "downloads" it into
Access, and then runs the query and spits out the results. When a
pass-through query is run, the command is sent to the server and just
the query's results are sent back to Access. You probably would not
notice much of a difference when using tables that don't have much
data, but when you are using tables with 1000's of records you will
certainly notice a difference.

.

Relevant Pages

  • Re: Update table from ODBC
    ... criteria are interpreted differently. ... SQLGetInfo and SQLGetTypeInfo to ask the ODBC driver whether the server ... If you want, post the SQL Strings of your Pass-Through Query, your Append ... Query using the Pass-through and your Append Query using ODBC-linked Table ...
    (microsoft.public.access.queries)
  • Re: SQL Pass-through Queries and List Boxes
    ... Am I right in thinking that if I use linked tables, then the query will ... seconds compared to 1/2 a second by SQL Server!! ... Rowsource to a 'dummy' PT query, create the SQL statement using VBA and pass ... but to use pass-through queries, ...
    (microsoft.public.access.modulesdaovba)
  • Re: creating forms for pass-through queries
    ... You can do a Make-Table query on your pass-through and set the TopValues property to be something like 50, which will give you 5o records to work with while you are testing -- then you don't have to worry about changing real data also. ... Is forms creation for pass-through queries very sluggish as in slow? ... be to manually key in data into combo/list down boxes right? ...
    (microsoft.public.access.forms)
  • Re: Access pass-through query to SQL DB
    ... not about ODBC linked tables and pass-through queries. ... The second clue would be to show us your piece of code. ... I want to build a pass-through query in MS Access 2003 to query a ... The ODBC connection is configure via control panel/admin tool/ODBC, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SELECT Case code failing
    ... I was not aware that my query had to be pass-through. ... "Tom Ellison" wrote: ... I am querying linked tables that point to an IBM Redbrick database. ...
    (microsoft.public.access.queries)