Dave,

I do have calculations on the layout, what is the work around?

Thanks,

Jason

On Jul 14, 2011, at 10:53 AM, David McQueen <[log in to unmask]> wrote:

> It sounds like either there is a sort within the script itself or
> going to that layout causes a sort of some type or perhaps invokes a
> calculation. The first time it runs the sort is slow over a LAN or
> WAN. Then the sort is remembered for that user.
>
> Check for sub summary parts and unstored calculations at that layout
> if there is no explicit sort step.
>
> Versions prior to FMP 11 (I believe that is the cutoff point) did not
> automatically sort summary layouts so that would not be an issue in
> prior versions.
>
> HTH
>
> Dave
>
>
>
> >Hello, I have script when ran for the first time is very slow from a
> >client. If I run the same script from Filemaker on the same box as
> >Filemaker server I do not see this delay. Any time I run the script
> >after the first run it is very fast. What should I look for to
> >trouble shoot this script? I have isolated the hang from one script
> >step. Go To Layout. I checked the layout for script triggers but it
> >doesn't have any. All machines run FileMaker Pro 11 and the database
> >is being served from Filemaker Pro Server 11 Any help is
> >appreciated. Thank you, Jason Bourque
> >
> >Hello,
> >
> >I have script when ran for the first time is very slow from a client.
> >If I run the same script from Filemaker on the same box as Filemaker
> >server I do not see this delay.
> >
> >Any time I run the script after the first run it is very fast.
> >
> >What should I look for to trouble shoot this script?
> >
> >I have isolated the hang from one script step. Go To Layout.
> >
> >I checked the layout for script triggers but it doesn't have any.
> >
> >All machines run FileMaker Pro 11 and the database is being served
> >from Filemaker Pro Server 11
> >
> >Any help is appreciated.
> >
> >Thank you,
> >
> >Jason Bourque
>
>
> -- 
> David A. McQueen
> LICHEN Software
> Barrie, ON, Canada
> 705-720-9022
> 705-728-2289
> http://www.lichen-software.com