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

[Gjermund Gusland Thorsen]

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
>