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

[Jonathan Schwartz]

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