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

[Dale Bengston]

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

On May 6, 2010, at 9:34 PM, Jon & Jane Montgomery wrote:

> On the subject of these offending auto-entry calc fields, what did you guys
> do to elemanate the congestion?  I have some auto-entry calc fields on
> record creation on a database that gets very slow.  I would like to fix that
> if you can be of help.
> 
> Respectfully,
> 
> Jon Montgomery
> 
> 
> On 5/6/10 6:54 PM, "Joel Shapiro" <jsfmp at earthlink.net> wrote:
> 
>> Just a "me too" to auto-enter calcs that were not on my web layout but
>> still causing huge delays.
>> 
>> -Joel
>> 
>> 
>> On May 6, 2010, at 4:49 PM, Dale Bengston wrote:
>> 
>>> Good stuff, Chris.
>>> 
>>> Since the topic of optimizing web layouts came up here and in one
>>> other post today, I will restate that my problems with record
>>> creation had to do with two auto-enter calc fields. The two
>>> offending auto-enter calc fields were among the 368 fields that were
>>> *not* on my web layout. This took me a long time to diagnose,
>>> because I knew my layout was completely stripped of all but the ten
>>> or so fields needed for the web.
>>> 
>>> Dale
>>> 
>>> On May 6, 2010, at 6:31 PM, Chris Hansen wrote:
>>> 
>>>> Jonathan,
>>>> 
>>>> A few thoughts:
>>>> 
>>>> 1) Does the deployment use IWP at all?  IWP will eat up one of your
>>>> 100 available connections for each person connected, even if
>>>> they're not doing anything;
>>>> 
>>>> 2) Are there unstored calcs or summary fields on any web layouts?
>>>> 
>>>> 3) Does the database have a close script, and if so, what does it
>>>> look like?  Just a while ago the WPE used to run the database's
>>>> close script on EVERY connection.  I'm not sure if this has been
>>>> fixed.  At the very least, this is something you could test for...
>>>> 
>>>> 4) What is the network connection like?  I wondering if the right
>>>> (wrong?) setup and/or a bad port might show its presence in this
>>>> way...  (Not sure about this, but I know from experience that
>>>> hardware problems can manifest themselves in interesting ways...)
>>>> 
>>>> Best,
>>>> 
>>>> --Chris
>>>> 
>>>> On May 6, 2010, at 12:21 PM, Jonathan Schwartz wrote:
>>>> 
>>>>> Hi Folks,
>>>>> 
>>>>> I'm wondering if anyone has experience with the negative impact of
>>>>> native FileMaker use on the same db/hardware/network etc that is
>>>>> used by php-based web users (fx.php/API/etc).
>>>>> 
>>>>> In short, I am trying to get to the bottom of severe web
>>>>> performance degradation during the day, as web transactions that
>>>>> normally take 0.1 second to perform will jump to 30  seconds or
>>>>> more.
>>>>> 
>>>>> I suspect that scripts running in native FileMaker are the
>>>>> culprit. The environment is FMS 10 in a 2 machine deployment.
>>>>> There are 10-20 native FileMaker users logged in on average. The
>>>>> hardware is Windows and the Task Manager(s) show the machines
>>>>> idling at all times...even during these overload times.  Perhaps I
>>>>> am not looking at the right indicators.
>>>>> 
>>>>> My first move to isolate the problem was to move the web-based
>>>>> data tables into a separate file from the one the native FileMaler
>>>>> users access. That didn't help much. The files still share the
>>>>> same hardware.
>>>>> 
>>>>> My next moves could include:
>>>>> - spin the web file to different hard drive/same machine
>>>>> - spin the web operation to different server
>>>>> - spin the web operation to different server at a different
>>>>> location.
>>>>> 
>>>>> Anyone?
>>>>> 
>>>>> Jonathan
>>>>> -- 
>>>>> 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
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list