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

Sun Dec 30 14:52:40 MST 2007

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

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