[AccessD] Could somebody expand on this a little?

Jim,

Thank you.  I've never used them.

Steve Erbach

On 1/30/06, Jim Lawrence <accessd at shaw.ca> wrote:
> Pass-through queries have terrible performance especially if you are trying
> to access dataset (recordsets).
>
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
> Sent: January 30, 2006 6:31 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Could somebody expand on this a little?
>
> Jim,
>
> Very interesting.  I noted that you and at least one other respondent
> mentioned pass-through queries as good performance options.
>
> What's puzzling to me, also, is a comment made to the article by
> Warren ( here's the link:
> http://www.sqlservercentral.com/columnists/awarren/linkingaccesstosqlserver.
> asp
> ):
>
> "Performance can really suck, depending on the application and the
> bandwidth. It has to do with the way data is cached in Access and
> becomes very apparent if you have large tables (>100,000 rows).
> However, it doesn't justify pass-through queries (obsolutely NOTHING
> justifies pass-through queries). Views (in SQL server) are your
> friend."
>
> "NOTHING justifies pass-through queries."  I didn't challenge him on
> that.  I should have, I suppose, but I know zip about pass-through
> queries.  What's your view?
> --
> Regards,
>
> Steve Erbach