[FX.php List] intermittent speed issues with fx.php and FMSA 9
Andy Walz
andywalz at wildernessinquiry.org
Wed Jan 2 21:30:10 MST 2008
Hmmmm... I didn't realize you could set disconnect when idle from
the privilege set level. I did not have that option checked.
Hopefully that will make all the difference when these "stagnant
connections" do happen. Thanks for the tip.
I am confident no one is connecting to our web database using a
FileMaker Client. The strange connections that I'm seeing in the
FMSA admin console are definitely from FX.php. They have the name
webuser which I defined and the fmxml extended privilege set
(filemaker clients show up as fmapp). What I still can't figure out
is that most of the time, like you, I do not see any xml client
connections in the admin console...even when there is heavy traffic,
but then every other day or so they start appearing and the whole
site slows down until I close and re-open the file. I keep thinking
I must have one bad query in some obscure place on the site but even
that shouldn't result in this kind of behavior.
At any rate I'll try it for a while with the disconnect option
enabled and let you know.
Thank you,
-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 Jan 2, 2008, at 6:21 PM, Andrew Denman wrote:
> Andy,
>
>
>
> I’m not on 9 yet, but here are some observations:
>
>
>
> - You can set the “disconnect user from FileMaker Server when idle”
> on the Edit Privilege Set page under Manage->Accounts &
> Privileges. You will have to do this for the privilege set in each
> file the web account has access to.
>
>
>
> - I have never seen an XML user show up in the connected clients
> list (though my connections may be too quick to show up). Is there
> anyone who would be connecting to your databases from a FileMaker
> client with the web user account?
>
>
>
> Andrew Denman
>
>
>
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-
> bounces at mail.iviking.org] On Behalf Of Andy Walz
> Sent: Sunday, December 30, 2007 2:28 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] intermittent speed issues with fx.php
> and FMSA 9
>
>
>
> 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/20080102/d2346096/attachment.html
More information about the FX.php_List
mailing list