[FX.php List] Web traffic versus native FileMaker use

Gjermund Gusland Thorsen ggt667 at gmail.com
Sun May 9 12:14:54 MDT 2010


Well, ideally closing and opening scripts should not cause problems
when script steps that involve user interface are avoided, however I
have found that not to be the the truth.

ggt

2010/5/8 Jon & Jane Montgomery <vicepresident at comcast.net>:
> Would an Open Script cause the same type of trouble?
>
> Jon Montgomery
>
>
> On 5/8/10 1:25 PM, "Gjermund Gusland Thorsen" <ggt667 at gmail.com> wrote:
>
>> Don¹t use it, it provokes some really bad errors in FileMaker.
>>
>> 2010/5/7 Jonathan Schwartz <jschwartz at exit445.com>:
>>> Great. Thanks for the confirmation.
>>>
>>>
>>> Now, who knows more about the "Close Script"  after every transaction issue?
>>>
>>> J
>>>
>>> At 12:07 PM -0500 5/7/10, Dale Bengston wrote:
>>>>
>>>> I don't think auto-enter calcs are a universal problem. In my case, web
>>>> record creation was being slowed to a crawl by an auto-enter calc that did
>>>> summation based on limits set by globals/constants. This worked fine
>>>> client-server, but from the web those limits were empty, so the summing
>>>> happened on the entire table. The more records that were added, the slower
>>>> it got.
>>>>
>>>> I modified two auto-enter calcs out of around 125 in order to fix this
>>>> problem. The rest continue to fire just as they do client-server.
>>>>
>>>> Dale
>>>>
>>>> On May 7, 2010, at 11:08 AM, Jonathan Schwartz wrote:
>>>>
>>>>>  A clarification on the potential problem with Auto_Entry Calc...
>>>>>
>>>>>  Are we talking about ALL auto entry calcs, or just ones that need to
>>>>> perform long process to calculate?
>>>>>
>>>>>  I understand the latter case, but not the former case... if the calc is
>>>>> just performing a simple operation such as random number generation.
>>>>>
>>>>>  Would like to know
>>>>>
>>>>>  Jonathan
>>>>>
>>>>>
>>>>>  At 9:45 PM -0500 5/6/10, Dale Bengston wrote:
>>>>>>
>>>>>>  I set a flag field in the parent (invoice) record that identified the
>>>>>> order as a web order. Then I wrapped the offending auto-enter calcs in a
>>>>>> conditional that only allowed the calculations to take place for line
>>>>>> items
>>>>>> created on orders with no web flag. This allowed the calcs to still happen
>>>>>> for client/server records.
>>>>>>
>>>>>>  Since this solution was not my work, it took several tedious hours of
>>>>>> trial and error to identify which fields had the offending calcs. There
>>>>>> were
>>>>>> a lot of auto-enter calc fields. A lot.
>>>>>>
>>>>>>  Dale
>>>>>>
>>>>>>
>>>>>>  > _______________________________________________
>>>>>>>
>>>>>>>  FX.php_List mailing list
>>>>>>>  FX.php_List at mail.iviking.org
>>>>>>>  http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>
>>>>>>  _______________________________________________
>>>>>>  FX.php_List mailing list
>>>>>>  FX.php_List at mail.iviking.org
>>>>>>  http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>
>>>>>
>>>>>  --
>>>>>  Jonathan Schwartz
>>>>>  Exit 445 Group
>>>>>  jonathan at exit445.com
>>>>>  http://www.exit445.com
>>>>>  415-370-5011
>>>>>  _______________________________________________
>>>>>  FX.php_List mailing list
>>>>>  FX.php_List at mail.iviking.org
>>>>>  http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>>
>>> --
>>> Jonathan Schwartz
>>> Exit 445 Group
>>> jonathan at exit445.com
>>> http://www.exit445.com
>>> 415-370-5011
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>


More information about the FX.php_List mailing list