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