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

[Jon & Jane Montgomery]

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