[AccessD] Could somebody expand on this a little?

Jim Lawrence accessd at shaw.ca
Mon Jan 30 14:01:21 CST 2006


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
Scientific Marketing
Neenah, WI
www.swerbach.com
Security Page: www.swerbach.com/security
http://TheTownCrank.blogspot.com



On 1/30/06, Jim Dettman <jimdettman at earthlink.net> wrote:
> Steve,
>
>   Andy doesn't seem to know much about Access.  You should have read his
> last Access article, which I and a few others commented on.  Here's the
> link:
>
>
http://www.sqlservercentral.com/columnists/awarren/diggingintoaccessperforma
> nce.asp
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steve Erbach
> Sent: Monday, January 30, 2006 7:53 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Could somebody expand on this a little?
>
>
> Dear Group,
>
> I read a recent SQL Server Central article by a fellow named Andy
> Warren that dealt with connecting to a SQL Server database using an
> Access MDB/ODBC connection.  The article very nicely laid out the
> step-by-step process -- with screen shots -- to accomplish this.  What
> made me curious about the article was that the author never mentioned
> ADP's.
>
> So I joined the discussion forum for this topic and read a number of
> interesting replies pro and con for MDBs vs. ADPs, some that I'm
> unable, from only my own experience, to evaluate.
>
> Here's one of them.  The forum member started his message by saying
> that the article was good.  He went on to say:
>
> ~~~~~~~~~~~~~~~~~~~~~~~~
> "Two problems I've come across:
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list