[AccessD] Slow Forms

Reuben:

Shot in the dark - try decompiling.  That sometimes works for me for no
apparent reason.

Rocky

----- Original Message ----- 
From: "Reuben Cummings" <reuben at gfconsultants.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, March 30, 2004 1:30 PM
Subject: RE: [AccessD] Slow Forms


> When I say slow I mean from 1 second before compacting to 11-15 seconds
the
> first time and 1 second afterward.
>
> In an mde it always takes about 11-15 seconds on my machine and 30 seconds
> across the network.
>
> I should have mentioned the app is split and in A2K.
>
> Reuben Cummings
> GFC, LLC
> phone: 812.523.1017
> email: reuben at gfconsultants.com
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Dettman
> > Sent: Tuesday, March 30, 2004 4:19 PM
> > To: Access Developers discussion and problem solving
> > Subject: RE: [AccessD] Slow Forms
> >
> >
> > Reuben,
> >
> > <<Everything worked very quickly until I compacted and repaired the db.
> > After
> > compacting, this form will open slowly one time and then open quickly
all
> > other times.  It will continue to open as I would expect it to until it
is
> > compacted again.>>
> >
> >   Not sure what you mean by "slow" (i.e. drastic difference?),
> > but you will
> > in general see that after any compact as the database stats are reset
and
> > all query plans are redone the first time a query is executed.
> >
> > Jim Dettman
> > President,
> > Online Computer Services of WNY, Inc.
> > (315) 699-3443
> > jimdettman at earthlink.net
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Reuben
> > Cummings
> > Sent: Tuesday, March 30, 2004 4:15 PM
> > To: AccessD
> > Subject: [AccessD] Slow Forms
> >
> >
> > I need help with a form that opens very slowly.
> >
> > Everything worked very quickly until I compacted and repaired the
> > db.  After
> > compacting, this form will open slowly one time and then open quickly
all
> > other times.  It will continue to open as I would expect it to until it
is
> > compacted again.
> >
> > However, if the app is made into an mde then it always opens slowly.
> >
> > The form is based on a query.  There is a tab control on it.  One tab
has
> > about 14 fields from the same recordsource as the main form.  The other
> > three tabs all have subforms based on queries.  2 of those queries have
> > fields that call functions to get their value.
> >
> > All the queries and subforms open very quickly.  And if I delete the
> > subforms, the main form will always operate quickly.
> >
> > I have imported into new db's.  I have completely rebuilt the main form.
> >
> > Any suggestions on where to start troubleshooting this thing?
> >
> > Thanks.
> >
> > Reuben Cummings
> > GFC, LLC
> > phone: 812.523.1017
> > email: reuben at gfconsultants.com
> >
> >
> >
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>