[AccessD] Slow Forms

Jim Dettman jimdettman at earthlink.net
Wed Mar 31 14:43:22 CST 2004


Reuben,

  Sounds like the costing plan being done for the queries.  I would not
consider it abnormal.

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:30 PM
To: Access Developers discussion and problem solving
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





More information about the AccessD mailing list