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

[Dale Bengston]

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