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

[Andy Walz]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20071230/31843fdd/attachment.html