[FX.php List] intermittent speed issues with fx.php and FMSA 9

Sun Dec 30 14:59:45 MST 2007

I run apache on g3/266 debianPPC and FMSA8.0v4r2 on 2.4GHz W2K3 server
with 2GB RAM

ggt

2007/12/30, Bob Patin <bob at patin.com>:
> Andy,
>
> While I'm not using FMSA 9 for FX.php sites, I have been using it for FM API
> sites, and have had some strange things happen with it, until I moved both
> web server and FMSA 9 to better machines.
>
> Now that I'm running the web server and FMSA 9 on better machines, I've had
> no trouble, no disconnects (which happened with the other pair of machines).
> What type of machines are you using? Perhaps this is related to the machines
> rather than the site. Also, do you have any other apps running on the FMSA
> machine, and if so, what are they?
>
> Best,
>
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> Member of FileMaker Business Alliance and FileMaker TechNet
>
>   CONTACT US VIA INSTANT MESSAGING:
>      AIM or iChat: longterm1954
>      Yahoo: longterm_solutions
>      MSN: tech at longtermsolutions.com
>      ICQ: 159333060
>
> --------------------------
> Contact us for FileMaker hosting and programming for all versions of
> FileMaker
> PHP • CDML • Full email services • Free DNS hosting • Colocation •
> Consulting
>
>
>
> On Dec 30, 2007, at 2:27 PM, Andy Walz wrote:
>
>
> ggt-  Thanks for the reply.  Can you explain what you mean by running apache
> and FMS on their own node?  Right now I have one OS 10.4.10 machine running
> Apache and FMSA 9.  The webpages and php files themselves are on a different
> server running Apache for several websites.
>
> Also, I think we've done a pretty good job of optimizing the layouts for
> each query. I realize how important that is.   Is it possible that a layout
> that is not optimized could cause the same query from php to be very fast
> one minute and then crippling slow the next?  What I'm getting at is that
> for days at time all of the queries on our website will work just
> fine...very fast in fact, and then all of sudden without explanation all the
> queries will be slow.  To fix the problem I find myself closing the db and
> re-opening it or disconnecting all the active webuser clients.  What is
> curious to me is that it seems like during normal operation webuser clients
> do not even show up in the FMSA Admin console...for example right now I can
> click around our site as much as I want and I do not see my status as a
> webuser client listed at all in the admin console.  do XML queries through
> FX typically result in extended webuser client sessions that display in FMSA
> Admin Console?  It seems to me that with XML it should just connect and
> disconnect each time but I guess I don't know enough about it.  Again any
> thoughts you have a greatly appreciated.
>
> Thanks again,
> Andy
>
>
> ________________________________________________________________________
> Serving people of all ages, backgrounds and abilities on shared outdoor
> experiences throughout the world. Visit us online at
> http://www.wildernessinquiry.org
>
> Andrew Walz, Program Director
> Wilderness Inquiry
> 808 14th Ave SE,
> Minneapolis, MN  55414
> (612)676-9412 Direct line
> (612)676-9400 General line
> (612)676-9401 Fax
>
>
>
> On Dec 30, 2007, at 12:38 PM, Gjermund Gusland Thorsen wrote:
>
> reduce the amount of fields pr layout, optimize them for each query.
>
> Run apache and FMS on each their node.
>
> ggt
>
>  Andy Walz <andywalz at wildernessinquiry.org>:
>  I'm new to the world of fx.php and FMSA 9 but am now supporting a fairly
> extensive website that uses both.  For the most part the site works
> great---even dynamic pages that display content using complex finds and
> sorts load in less than 3 seconds. On what seems to be random occasions
> (that happen slightly too often!) I find the site slowed to a crawl
> rendering it almost useless.  At these times, pages that normally take 1 or
> 2 seconds to load take 12,15, 30 seconds or sometimes even several minutes.
> During these slow-downs the only thing out of the ordinary that I can find
> is that when I look at the list of connected clients in FMSA 9 there are
> between 4 and 20 "webuser" clients (the account our fx uses) listed as
> connected with connect times sometimes more than an hour old.  When I
> forcefully disconnect the stagnant webuser clients (or restart the server
> entirely) the speed of the site returns.
>
> Have any of you experienced anything like this?  Any ideas as how I might
> find the source of this issue and/or prevent it?
>
> Is there anyway to set a timeout for XML connections in the same way that
> you can set a session timeout for FM Instant Web Publishing?
>
> Thanks in advance,
> Andy Walz
>
>
> ________________________________________________________________________
> Serving people of all ages, backgrounds and abilities on shared outdoor
> experiences throughout the world. Visit us online at
> http://www.wildernessinquiry.org
>
> Andrew Walz, Program Director
> Wilderness Inquiry
> 808 14th Ave SE,
> Minneapolis, MN  55414
> (612)676-9412 Direct line
> (612)676-9400 General line
> (612)676-9401 Fax
>
>
> _______________________________________________
> 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
>
>