[AccessD] FW: Performance tips anyone?

jwcolby jwcolby at colbyconsulting.com
Thu Jul 5 08:28:05 CDT 2007

Can our list manager help Thomas figure out why he gets bounce messages.
His messages are getting through but he is being told they aren't.

John W. Colby
Colby Consulting



From: ewaldt at gdls.com [mailto:ewaldt at gdls.com] 
Sent: Thursday, July 05, 2007 9:07 AM
To: jwcolby at colbyconsulting.com
Subject: Re: Performance tips anyone?


I keep sending this to the list, but it keeps being rejected; something
about "the recipient's BlackBerry Handheld". Anyway, thought I'd send it on
to you. You've probably already thought of it, but just in case... 

Could you include code in a module 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

More information about the AccessD mailing list