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

[Dale Bengston]

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