[AccessD] More on the 2007 ADP issue

Mark Simms marksimms at verizon.net
Mon Nov 15 13:32:04 CST 2010


Great tip David....greatly appreciated.
It's amazing to see how "little things" can make a huge difference in
performance.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> David McAfee
> Sent: Monday, November 15, 2010 1:00 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] More on the 2007 ADP issue
>
> I work strictly with ADPs.
>
> I noticed if you don't use dbo. in front of queries and
> stored procedures it can really slow things down a bit.
>
> Otherwise, my ADPs seem to work great in A2007.
>
> Another thing, if your views and stored procedures are read
> only, make your you use WITH (NOLOCK) after the table names
> in select statements.
>





More information about the AccessD mailing list