[FX.php List] I just installed FMSA 11 and WPE on each their machine
Gjermund Gusland Thorsen
ggt667 at gmail.com
Mon Jun 28 17:35:50 MDT 2010
as a 2 machine solution
it works nicely at first
$ time curl "http://user:passwd@10.0.0.100:80/fmi/xml/FMPXMLRESULT.xml?-db=Document&-lay=Weblookup&-findany";echo
<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN"
"/fmi/xml/FMPXMLRESULT.dtd"><FMPXMLRESULT
xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>0</ERRORCODE><PRODUCT
BUILD="01/27/2010" NAME="FileMaker Web Publishing Engine"
VERSION="11.0.1.86"/><DATABASE DATEFORMAT="MM/dd/yyyy"
LAYOUT="WebLookup" NAME="Document" RECORDS="500361"
TIMEFORMAT="HH:mm:ss"/><METADATA><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="URL" TYPE="TEXT"/><FIELD EMPTYOK="NO" MAXREPEAT="1"
NAME="webLookup" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="Globals::documentPathProduction" TYPE="TEXT"/><FIELD
EMPTYOK="YES" MAXREPEAT="1" NAME="attachmentLocation"
TYPE="TEXT"/></METADATA><RESULTSET FOUND="1"><ROW MODID="13"
RECORDID="59038"><COL><DATA>http://www.appendiks.no/Document/PO/2007/11/OSL-64401/20071107100021252.pdf</DATA></COL><COL><DATA>Ym8EIG2xLiDEuSFBF8o</DATA></COL><COL><DATA>http://www.appendiks.no/</DATA></COL><COL><DATA>PO/2007/11/OSL-64401/20071107100021252.pdf</DATA></COL></ROW></RESULTSET></FMPXMLRESULT>
real 0m0.108s
user 0m0.010s
sys 0m0.010s
But then after 25-50 queries response time is like amazingly 1
MINUTE!!! 24.087s:
$ time curl "http://user:passwd@10.0.0.100:80/fmi/xml/FMPXMLRESULT.xml?-db=Document&-lay=Weblookup&-findany";echo
<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN"
"/fmi/xml/FMPXMLRESULT.dtd"><FMPXMLRESULT
xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>0</ERRORCODE><PRODUCT
BUILD="01/27/2010" NAME="FileMaker Web Publishing Engine"
VERSION="11.0.1.86"/><DATABASE DATEFORMAT="MM/dd/yyyy"
LAYOUT="WebLookup" NAME="Document" RECORDS="500361"
TIMEFORMAT="HH:mm:ss"/><METADATA><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="URL" TYPE="TEXT"/><FIELD EMPTYOK="NO" MAXREPEAT="1"
NAME="webLookup" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1"
NAME="Globals::documentPathProduction" TYPE="TEXT"/><FIELD
EMPTYOK="YES" MAXREPEAT="1" NAME="attachmentLocation"
TYPE="TEXT"/></METADATA><RESULTSET FOUND="1"><ROW MODID="18"
RECORDID="32009"><COL><DATA>http://www.appendiks.no/Document/f/2007/06/S33484/unknown.2.html</DATA></COL><COL><DATA>6LpbTEHv2okLPGH7HQD</DATA></COL><COL><DATA>http://www.appendiks.no/</DATA></COL><COL><DATA>f/2007/06/S33484/unknown.2.html</DATA></COL></ROW></RESULTSET></FMPXMLRESULT>
real 1m24.087s
user 0m0.010s
sys 0m0.020s
The setup is a
MacMini with 4GB RAM and 30GB SSD, running ONLY FMSA worker
XServe with 8GB RAM and 3x135GB 15000RPM disks, running FMSA
Gigabit inbetween
queries are the same whether done from a local workstation on the LAN
or the WPE machine itself.
Anyone got a clue to why this happens?
After even longer an Error 503, Service temporarily Unavailable will occur
and after 15 mins there will be 404, Not Found will show up
ggt
More information about the FX.php_List
mailing list