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

Wed Jan 2 17:21:03 MST 2008

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

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