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

[Joel Shapiro]

Hey Jonathan

Would the WebDB have its own data, or just be a "UI" file pointing at  
the data in MainDB?  If the latter, I don't think separating it out  
would make a difference w/ these problems.

Can you see anything relevant in the FMS Admin Console during one of  
the slowdowns?  Under Statistics or under Clients? (under Clients you  
should see "Web" when the web user is being held up)

-Joel



On May 6, 2010, at 12:47 PM, Jonathan Schwartz wrote:

> Hey Joel,
>
> No PHP scripts calling FileMaker scripts.
>
> Since writing the original post...only minutes ago....my thinking  
> has matured.  There is stuff going on in the  native solution (not  
> under my control) that will continue to go on. I have now decided to  
> isolate the web solution from it rather than attempt to fix the  
> other side.
>
> So, the question now boils down to practical ways to isolate a web  
> solution from a 2 machine deployment, where:
> 	Machine1 = FMSserver 10 with MainDB and WebDB
> 	Machine2 = FMSserver 10 Web Engine, serving WebDB
>
> This one just ocurred to me: Turn Machine 2 into a single machine  
> deployment Web Publishing machine running the WEBDB. This will  
> probably mean purchasing another copy of FMServer.
>
> Short of doing this, I was wondering if simply adding a new hard  
> drive for the WebDB into machine 1 would be of any benefit.
>
> That's where I am right now.
>
> Jonathan
>
>
>
>
>
> At 12:12 PM -0700 5/6/10, Joel Shapiro wrote:
>> Hey Jonathan
>>
>> It seems that if your performance picks back up again in the  
>> evening, then it's probably not connected to slow record creation  
>> (I also had a recent web slowdown due to their FMP person having  
>> added auto-enter calc fields based on a bad relationship).
>>
>> Are those FM scripts connected to the PHP calls to the DB, or are  
>> they being run by users in FMP?  If they're called by the PHP, can  
>> you temporarily disable them to test whether or not they're the  
>> cause?
>>
>> HTH,
>> -Joel
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~
>> Joel Shapiro
>> FileMaker Pro
>> database & web design
>> http://www.jsfmp.com
>> 415-269-5055
>> ~~~~~~~~~~~~~~~~~~~~~~~
>
> -- 
> 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