[AccessD] Form Opening Time

Hello Bryan,

can you give me some information about Jet's showplan in the registry.
What does it do?
I have a form that needs about 35 sec to open, So this could be a great
help.

Pedro Janssen



----- Original Message -----
From: "Bryan Carbonnell" <Bryan_Carbonnell at cbc.ca>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, April 20, 2004 9:31 PM
Subject: Re: [AccessD] Form Opening Time


> OOPS.
>
> A2K SP3
>
> Bryan
>
> >>> Bryan_Carbonnell at cbc.ca 20-Apr-04 3:18:04 PM >>>
> Access 2000 on Win 2K SP4 with Jet 4, SP8
>
> Bryan Carbonnell
> bryan_carbonnell at cbc.ca
>
> >>> gustav at cactus.dk 20-Apr-04 3:04:25 PM >>>
> Hi Bryan
>
> Which version, please?
>
> /gustav
>
>
> > Can anyone explain, or give a possible idea why Turning Jet's
> SHOWPLAN
> > on in the registry, will make a form open in 1/3 of the time it took
> > prior to turning it on?
>
> > It now takes about 7 seconds to open, but before it was 22-24
> secords.
>
> > Any ideas? I had turned on SHOWPLAN to try and see if any of the
> > queries were causing the slowdown in opening.
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>