[AccessD] Performance tips anyone?

Yep, I need to do something like this.  Often in Access this isn't very
feasible since many people use references to controls on forms, which means
the form has to be open to cause the query to run.  I stopped using that
method long ago, preferring to use "filters" (static functions) to pass
parameters to queries.  So I can probably write code to iterate the querydef
collection, grabbing the name of each query and executing it.  Even then it
could take awhile to execute every query in a FE.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ewaldt at gdls.com
Sent: Thursday, July 05, 2007 8:05 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Performance tips anyone?

John:

Could you include code to open and close all queries, "hide" the code so
only you run it, but then run it before posting the new update to the FE? 
That should recreate any query plans, shouldn't it?

Thomas F. Ewald
Stryker Mass Properties
General Dynamics Land Systems


John Colby responded to Steve Schapel:

Ohhhh that is something to consider, I kinda knew this but never thought of
it in quite this light.  I build and then upload to a server.  The users
download the FE every day.  Thus the first time they open anything it will
be slow, every day.  Sigh.

Steve had said:

And here's another thing I only found out about this week... the first time
a saved query is run after the database is compacted, will be slow, because
the query plan has to be re-created.  So if you compact/repair the front-end
application file, queries will run slow the first time, and forms based on
queries will open slowly the first time.


This is an e-mail from General Dynamics Land Systems. It is for the intended
recipient only and may contain confidential and privileged information.  No
one else may read, print, store, copy, forward or act in reliance on it or
its attachments.  If you are not the intended recipient, please return this
message to the sender and delete the message and any attachments from your
computer. Your cooperation is appreciated.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com