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

Sun May 9 13:16:21 MDT 2010

Ggt,
    Thank you and others on this thread.  I have a FMP database that failed
me in that it crashed the server 2 times in 4 hours at the time, just
realized that maybe I was asking FMP to do more than it could handle.  We
were trying edit 16,000 records in about 8 hours.  We managed to edit about
4,500 records in that 4 hour period including the down time of the server.
It has to be my design both PHP and FileMaker I think.  Just looking for
answers.  The the traffic increased, it became slower and slower.  Not the
host's problem, as it is a very good company with a great setup.  Had to be
something or lots of somethings my lack of experience caused. Code writing
(it was API and NOT FX (which I would have prefered but did not use.)  and
more than likely bad database design.
    Thanks for the info from everybody here.  I have now been replaced on
that job and do not want to make those mistakes again.

Jon Montgomery

On 5/9/10 1:14 PM, "Gjermund Gusland Thorsen" <ggt667 at gmail.com> wrote:

> 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
>> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list