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

[Chris Hansen]

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
>