FileMaker Server 14 response times

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

FileMaker Server 14 response times

Johan Solve
We're seing much slower response times in WPE XML (what Lasso uses) from
FMS14 than FMS12. Like 10x slower. Cross-tested with different servers on
FMS12 and FMS14, and the results are consistent.

Then expanded the tests to FMS13 and 15 also, and they all perform as they
should. Response times around 100-200 ms for our reference queries. FMS 14
remains sluggish with response times around 1-3 seconds. Same database and
query used for testing on different servers of each version.

What's wrong with FileMaker Server 14?

--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: FileMaker Server 14 response times

maxwellk2
Which OS? The only thing that comes to mind is a old post about a bug in FMS13, maybe they still haven't fixed it in FMS14:

        http://lasso.2283332.n4.nabble.com/Lasso-8-6-3-on-Windows-2008R-with-Filemaker-13-on-Windows-2012-td4643274.html

Unfortunately the links in that post to the fix are broken. Maybe Rachel or Liz can confirm, but the following post might contain that fix:

        https://community.filemaker.com/thread/134694

There is a "Workaround" section further down in that post that describes a fix by modifying FileMaker's Tomcat server.xml config file.

-Max


> On Sep 30, 2016, at 12:22 AM, Johan Solve <[hidden email]> wrote:
>
> We're seing much slower response times in WPE XML (what Lasso uses) from
> FMS14 than FMS12. Like 10x slower. Cross-tested with different servers on
> FMS12 and FMS14, and the results are consistent.
>
> Then expanded the tests to FMS13 and 15 also, and they all perform as they
> should. Response times around 100-200 ms for our reference queries. FMS 14
> remains sluggish with response times around 1-3 seconds. Same database and
> query used for testing on different servers of each version.
>
> What's wrong with FileMaker Server 14?
>
> --
> Mvh
> Johan Sölve
> ____________________________________
> Montania System AB
> Halmstad   Stockholm
> http://www.montania.se
>
> Johan Sölve
> Mobil +46 709-51 55 70
> [hidden email]
>
> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> Telefon +46 35-136800 |  Fax +46 35-136801
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: FileMaker Server 14 response times

Johan Solve
For FMS 14, Windows 2008 Server and Windows 2012 Server was used.
FMS 12 on Windows 2008 Server and MacOS.
FMS 13 on MacOS.
FMS 15 on Windows Server 2012.

All Windows servers on VPS. 2008 on VMWare and 2012 on Hyper V.
MacOS on fairly old Mac Mini hardware with rotating disks.

Thanks for your interesting links that even Filemaker's TS Gal found
interesting. Will look closer at the Tomcat server.xml lead.



fredag 30 september 2016 skrev Maxwell Klein <[hidden email]>:

> Which OS? The only thing that comes to mind is a old post about a bug in
> FMS13, maybe they still haven't fixed it in FMS14:
>
>         http://lasso.2283332.n4.nabble.com/Lasso-8-6-3-on-
> Windows-2008R-with-Filemaker-13-on-Windows-2012-td4643274.html
>
> Unfortunately the links in that post to the fix are broken. Maybe Rachel
> or Liz can confirm, but the following post might contain that fix:
>
>         https://community.filemaker.com/thread/134694
>
> There is a "Workaround" section further down in that post that describes a
> fix by modifying FileMaker's Tomcat server.xml config file.
>
> -Max
>
>
> > On Sep 30, 2016, at 12:22 AM, Johan Solve <[hidden email]
> <javascript:;>> wrote:
> >
> > We're seing much slower response times in WPE XML (what Lasso uses) from
> > FMS14 than FMS12. Like 10x slower. Cross-tested with different servers on
> > FMS12 and FMS14, and the results are consistent.
> >
> > Then expanded the tests to FMS13 and 15 also, and they all perform as
> they
> > should. Response times around 100-200 ms for our reference queries. FMS
> 14
> > remains sluggish with response times around 1-3 seconds. Same database
> and
> > query used for testing on different servers of each version.
> >
> > What's wrong with FileMaker Server 14?
> >
> > --
> > Mvh
> > Johan Sölve
> > ____________________________________
> > Montania System AB
> > Halmstad   Stockholm
> > http://www.montania.se
> >
> > Johan Sölve
> > Mobil +46 709-51 55 70
> > [hidden email] <javascript:;>
> >
> > Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> > Telefon +46 35-136800 |  Fax +46 35-136801
> >
> > #############################################################
> >
> > This message is sent to you because you are subscribed to
> >  the mailing list Lasso [hidden email] <javascript:;>
> > Official list archives available at http://www.lassotalk.com
> > To unsubscribe, E-mail to: <[hidden email]
> <javascript:;>>
> > Send administrative queries to  <[hidden email]
> <javascript:;>>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email] <javascript:;>
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]
> <javascript:;>>
> Send administrative queries to  <[hidden email]
> <javascript:;>>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: FileMaker Server 14 response times

maxwellk2
Sorry, looks like this reply from Oct 1st bounced, I probably set it from the wrong account…...


I got a FMS14 install turned up under a Parallels VM, FMS 14.0.4.414, Mac OS 10.11.6. Have a separate Parallels VM, Lasso 8.6.3, Mac OS 10.10.5. Got a zip code database with 42,500 records. Using Jason Huck's timer tag I can display all zip codes in 9082ms, all California zip codes in 613ms, and 1 zip code in 14ms.

Do you have any specific code you'd like me to try?

I noticed you're only FMS14 test was under Windows. Hopefully this is the server.xml bug jbarnum (Jesse Barnum from 360Works.com) found a fix for. I've not see this issue for any Mac installs, but have experienced it under Windows before it was a known bug.

-Max




> On Sep 30, 2016, at 2:56 PM, Johan Solve <[hidden email]> wrote:
>
> For FMS 14, Windows 2008 Server and Windows 2012 Server was used.
> FMS 12 on Windows 2008 Server and MacOS.
> FMS 13 on MacOS.
> FMS 15 on Windows Server 2012.
>
> All Windows servers on VPS. 2008 on VMWare and 2012 on Hyper V.
> MacOS on fairly old Mac Mini hardware with rotating disks.
>
> Thanks for your interesting links that even Filemaker's TS Gal found
> interesting. Will look closer at the Tomcat server.xml lead.
>
>
>
> fredag 30 september 2016 skrev Maxwell Klein <[hidden email]>:
>
>> Which OS? The only thing that comes to mind is a old post about a bug in
>> FMS13, maybe they still haven't fixed it in FMS14:
>>
>>        http://lasso.2283332.n4.nabble.com/Lasso-8-6-3-on-
>> Windows-2008R-with-Filemaker-13-on-Windows-2012-td4643274.html
>>
>> Unfortunately the links in that post to the fix are broken. Maybe Rachel
>> or Liz can confirm, but the following post might contain that fix:
>>
>>        https://community.filemaker.com/thread/134694
>>
>> There is a "Workaround" section further down in that post that describes a
>> fix by modifying FileMaker's Tomcat server.xml config file.
>>
>> -Max
>>
>>
>>> On Sep 30, 2016, at 12:22 AM, Johan Solve <[hidden email]
>> <javascript:;>> wrote:
>>>
>>> We're seing much slower response times in WPE XML (what Lasso uses) from
>>> FMS14 than FMS12. Like 10x slower. Cross-tested with different servers on
>>> FMS12 and FMS14, and the results are consistent.
>>>
>>> Then expanded the tests to FMS13 and 15 also, and they all perform as
>> they
>>> should. Response times around 100-200 ms for our reference queries. FMS
>> 14
>>> remains sluggish with response times around 1-3 seconds. Same database
>> and
>>> query used for testing on different servers of each version.
>>>
>>> What's wrong with FileMaker Server 14?
>>>
>>> --
>>> Mvh
>>> Johan Sölve
>>> ____________________________________
>>> Montania System AB
>>> Halmstad   Stockholm
>>> http://www.montania.se
>>>
>>> Johan Sölve
>>> Mobil +46 709-51 55 70
>>> [hidden email] <javascript:;>
>>>
>>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>>> Telefon +46 35-136800 |  Fax +46 35-136801
>>>
>>> #############################################################
>>>
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso [hidden email] <javascript:;>
>>> Official list archives available at http://www.lassotalk.com
>>> To unsubscribe, E-mail to: <[hidden email]
>> <javascript:;>>
>>> Send administrative queries to  <[hidden email]
>> <javascript:;>>
>>
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>>  the mailing list Lasso [hidden email] <javascript:;>
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]
>> <javascript:;>>
>> Send administrative queries to  <[hidden email]
>> <javascript:;>>
>
>
>
> --
> Mvh
> Johan Sölve
> ____________________________________
> Montania System AB
> Halmstad   Stockholm
> http://www.montania.se
>
> Johan Sölve
> Mobil +46 709-51 55 70
> [hidden email]
>
> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> Telefon +46 35-136800 |  Fax +46 35-136801
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: FileMaker Server 14 response times

Johan Solve
Max,

Thanks for your input on this. I haven't done further investigations on the
server.xml lead, but instead ran performance tests comparing FMS13 on Mac
with FMS15 on virtualized Windows Server 2012 R2. My conclusion is that the
response times for raw WPE requests (search and add) are nearly identical,
in both cases 30-60 ms (average 32 ms) across 100 queries with ab.

So we're moving this solution to FMS15 on Windows.


On 11 October 2016 at 19:44, Maxwell Klein <[hidden email]> wrote:

> Sorry, looks like this reply from Oct 1st bounced, I probably set it from
> the wrong account…...
>
>
> I got a FMS14 install turned up under a Parallels VM, FMS 14.0.4.414, Mac
> OS 10.11.6. Have a separate Parallels VM, Lasso 8.6.3, Mac OS 10.10.5. Got
> a zip code database with 42,500 records. Using Jason Huck's timer tag I can
> display all zip codes in 9082ms, all California zip codes in 613ms, and 1
> zip code in 14ms.
>
> Do you have any specific code you'd like me to try?
>
> I noticed you're only FMS14 test was under Windows. Hopefully this is the
> server.xml bug jbarnum (Jesse Barnum from 360Works.com) found a fix for.
> I've not see this issue for any Mac installs, but have experienced it under
> Windows before it was a known bug.
>
> -Max
>
>
>
>
> > On Sep 30, 2016, at 2:56 PM, Johan Solve <[hidden email]> wrote:
> >
> > For FMS 14, Windows 2008 Server and Windows 2012 Server was used.
> > FMS 12 on Windows 2008 Server and MacOS.
> > FMS 13 on MacOS.
> > FMS 15 on Windows Server 2012.
> >
> > All Windows servers on VPS. 2008 on VMWare and 2012 on Hyper V.
> > MacOS on fairly old Mac Mini hardware with rotating disks.
> >
> > Thanks for your interesting links that even Filemaker's TS Gal found
> > interesting. Will look closer at the Tomcat server.xml lead.
> >
> >
> >
> > fredag 30 september 2016 skrev Maxwell Klein <[hidden email]>:
> >
> >> Which OS? The only thing that comes to mind is a old post about a bug in
> >> FMS13, maybe they still haven't fixed it in FMS14:
> >>
> >>        http://lasso.2283332.n4.nabble.com/Lasso-8-6-3-on-
> >> Windows-2008R-with-Filemaker-13-on-Windows-2012-td4643274.html
> >>
> >> Unfortunately the links in that post to the fix are broken. Maybe Rachel
> >> or Liz can confirm, but the following post might contain that fix:
> >>
> >>        https://community.filemaker.com/thread/134694
> >>
> >> There is a "Workaround" section further down in that post that
> describes a
> >> fix by modifying FileMaker's Tomcat server.xml config file.
> >>
> >> -Max
> >>
> >>
> >>> On Sep 30, 2016, at 12:22 AM, Johan Solve <[hidden email]
> >> <javascript:;>> wrote:
> >>>
> >>> We're seing much slower response times in WPE XML (what Lasso uses)
> from
> >>> FMS14 than FMS12. Like 10x slower. Cross-tested with different servers
> on
> >>> FMS12 and FMS14, and the results are consistent.
> >>>
> >>> Then expanded the tests to FMS13 and 15 also, and they all perform as
> >> they
> >>> should. Response times around 100-200 ms for our reference queries. FMS
> >> 14
> >>> remains sluggish with response times around 1-3 seconds. Same database
> >> and
> >>> query used for testing on different servers of each version.
> >>>
> >>> What's wrong with FileMaker Server 14?
> >>>
> >>> --
> >>> Mvh
> >>> Johan Sölve
> >>> ____________________________________
> >>> Montania System AB
> >>> Halmstad   Stockholm
> >>> http://www.montania.se
> >>>
> >>> Johan Sölve
> >>> Mobil +46 709-51 55 70
> >>> [hidden email] <javascript:;>
> >>>
> >>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> >>> Telefon +46 35-136800 |  Fax +46 35-136801
> >>>
> >>> #############################################################
> >>>
> >>> This message is sent to you because you are subscribed to
> >>> the mailing list Lasso [hidden email] <javascript:;>
> >>> Official list archives available at http://www.lassotalk.com
> >>> To unsubscribe, E-mail to: <[hidden email]
> >> <javascript:;>>
> >>> Send administrative queries to  <[hidden email]
> >> <javascript:;>>
> >>
> >>
> >> #############################################################
> >>
> >> This message is sent to you because you are subscribed to
> >>  the mailing list Lasso [hidden email] <javascript:;>
> >> Official list archives available at http://www.lassotalk.com
> >> To unsubscribe, E-mail to: <[hidden email]
> >> <javascript:;>>
> >> Send administrative queries to  <[hidden email]
> >> <javascript:;>>
> >
> >
> >
> > --
> > Mvh
> > Johan Sölve
> > ____________________________________
> > Montania System AB
> > Halmstad   Stockholm
> > http://www.montania.se
> >
> > Johan Sölve
> > Mobil +46 709-51 55 70
> > [hidden email]
> >
> > Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> > Telefon +46 35-136800 |  Fax +46 35-136801
> >
> > #############################################################
> >
> > This message is sent to you because you are subscribed to
> >  the mailing list Lasso [hidden email]
> > Official list archives available at http://www.lassotalk.com
> > To unsubscribe, E-mail to: <[hidden email]>
> > Send administrative queries to  <[hidden email]>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>