[AccessD] Performance tips anyone?

Steve:
I have made this change in production apps, and have seen the time drop from
minutes to seconds. 

Steve


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Thursday, July 05, 2007 12:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Performance tips anyone?

Sorry to be contrary, Steve, but I don't think this is supported by the
evidence.  In fact, I believe DoCmd.OpenQuery would perform faster if you
are running a saved query, as long as the number of records hasn't changed
dramatically since the last time it was run.  But either way, I think this
is possibly academic interest only, as the speed differences here are likely
to be imperceptible.

Regards
Steve


Steve Conklin wrote:
> Replace any DoCmd.RunSQL's with CurrentDB.execute.
> 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com