<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Andreas,<br>
<br>
The problem with Apache is that the QGIS Server processes are
regularly reset. So the QGIS Server cache is regularly cleaned, and
the project is regularly reloaded. So the project is not loading
every time a request is being made but some time.<br>
<br>
I have opened an issue to have min, max and median requests time to
have a better idea of the performances. But I have no skill in SCALA
and Gatling to propose a PR.<br>
<br>
It will be great to test other Web Server like Nginx/Supervisor or
Tornado embedding QGIS Server.<br>
<br>
Regards,<br>
René-Luc<br>
<br>
<div class="moz-cite-prefix">Le 08/02/2018 à 15:59, Andreas Neumann
a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:16779e33c3f70723222bf9e6c3dc5af3@carto.net">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<p>Hi René Luc,</p>
<p>Good points. I also had a look at these stats and was
disappointed.</p>
<p>So I agree that it would be worth-wile working on improving the
performance of QGIS server version 3.</p>
<p>On the QgsProject loading performance issue: is this only an
issue at the first loading of the project or every time a
request is being made?</p>
<p>Definitely I would welcome a submission at the next round of
QGIS grants to further study the issues and improve perfomance
were possible.</p>
<p>Thanks for your thoughts,</p>
<p>Andreas</p>
<p>On 2018-02-08 15:19, René-Luc Dhont wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left:
#1010ff 2px solid; margin: 0"><!-- html ignored -->
<!-- head ignored --><!-- meta ignored --> Hi Devs,<br>
<br>
I have made some analyse of the performances data generated by
CampToCamp test platform.<br>
The data are downloadable here <a class="moz-txt-link-freetext"
href="https://gmf-test.sig.cloud.camptocamp.net/ms_perfs/"
target="_blank" rel="noopener noreferrer"
moz-do-not-send="true">https://gmf-test.sig.cloud.camptocamp.net/ms_perfs/</a><br>
And the tests are based on this docker-pull: <a
class="moz-txt-link-freetext"
href="https://github.com/camptocamp/ms_perfs" target="_blank"
rel="noopener noreferrer" moz-do-not-send="true">https://github.com/camptocamp/ms_perfs</a><br>
<br>
The QGIS Server docker used for these tests are based on the
Kartoza one updated by CampToCamp<br>
<a class="moz-txt-link-freetext"
href="https://github.com/kartoza/docker-qgis-server"
target="_blank" rel="noopener noreferrer"
moz-do-not-send="true">https://github.com/kartoza/docker-qgis-server</a>
It is based on Apache Server and FCGI.<br>
<br>
The data comes from OpenStreetMap and are stored in a
PostgreSQL/PostGIS database.<br>
One type of request is tested, GetMap. Varoious number of
simultaneous users and various scale <br>
are tested.<br>
<br>
To give an answer to the question : Is QGIS Server 3 fast yet ?
, I only used the values for 10 simultaneous<br>
users.<br>
<br>
If the reference to the question is QGIS Server 2: QGIS Server 3
is NOT faster even with the trust option activated in the
project.<br>
QGIS Server 3 is always slower than QGIS Server 2, when only one
layer is requested.<br>
In the tests, QGIS Sever 3 is faster than QGIS Server 2 with
multi-layers and complex styles.<br>
<br>
This result can be easily explain by the new way QGIS Server is
loaded project. QGIS Server 3 uses the QgsProject class, so all
the <br>
project : layers and layouts are loaded even if only one layer
is requested.<br>
<br>
About the trust project option, the results are a little bit <span
id="result_box" class="short_text"><span>disappointing. The
performances are not always better than without.<br>
For higher scale (1° by 800px), requests are slower, but for
lower scale (</span></span><span id="result_box"
class="short_text"><span><span id="cwos" class="cwcot">0.015</span></span></span><span
id="result_box" class="short_text"><span><span id="cwos"
class="cwcot"><span id="cwos" class="cwcot">625° by 800px)</span></span>,
they are faster.<br>
<br>
Now if we consired GeoServer-jai as a reference, QGIS Server
3 is slower in lower sacle (0.03125° by 800px)<br>
</span></span><span id="result_box" class="short_text"><span><span
id="result_box" class="short_text"><span>Now if we
consired Mapserver as a reference, QGIS Server 3 is
slower!<br>
<br>
We have to test some configuration:<br>
* disable simplify local<br>
* change simplify max scale<br>
<br>
Points of enhancement have to be explored :<br>
* Faster QgsProject loading based on project parsing <br>
* Simplify configuration at layer level<br>
* Completing trust option<br>
<br>
Regards,<br>
René-Luc<br>
* Enhance simplification<br>
</span></span></span></span><!-- html ignored --><br>
<div class="pre" style="margin: 0; padding: 0; font-family:
monospace">_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org"
moz-do-not-send="true">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-developer"
target="_blank" rel="noopener noreferrer"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-developer"
target="_blank" rel="noopener noreferrer"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></div>
</blockquote>
<p><br>
</p>
</blockquote>
<br>
</body>
</html>