[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