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

Sun Dec 30 14:57:21 MST 2007

2007/12/30, Andy Walz <andywalz at wildernessinquiry.org>:
>
> 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.

Good, so you do this without exhaustive collisions on localhost, that's superb!

> 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.

How often do you run backups? And do you do backups with consistency check?

I notice a general lower CPU usage when I switch off XSLT and IWP in
the admin panel of FMSA8.0v4r2

>
> 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
>
>