<div dir="ltr"><div><div><div><div><div><div><div>Hi,<br>thx for response.<br><br></div>I tested my project with qgis desktop dev version from osgeo4w 32 bit. AFAIK it is a spatialite 4.1.1.<br><br></div>In my server machine I use still spatialite 4.1.1 compiled from sources.<br>
</div>So I guess the libspatialite version is the same.<br><br></div>But as I report in the qgis compile settings there is a "use spatialite internal".<br></div>I don't know what is mean and so I try with and without it.<br>
<br></div><div>To avoid the getcapability slow I bypass that phase in my framework and go directly to the GetMap phase.<br></div><div>But also it seem a bit slow.<br></div><div>Using the same map at the same scale:<br>In my desktop it come in about 2 seconds.<br>
In my qgis-server machine it come in 10 seconds.<br>This difference I guess is not all due to the missing of fastcgi.<br></div><br></div><div>Now I'm study how to add a fastcgi container (I like JFastCGI ) to test what change with it.<br>
</div><div><br></div><br><div>A.<br><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-02-14 9:08 GMT+01:00 Marco Hugentobler <span dir="ltr"><<a href="mailto:marco.hugentobler@sourcepole.ch" target="_blank">marco.hugentobler@sourcepole.ch</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi Andrea<div class=""><br>
<br>
>I suspect that QS try always to recalc the box of every layer.<br>
<br></div>
QGIS server caches layers (up to 100, but that can be enhanced
using the environment variable MAX_CACHE_LAYERS). Furthermore,
the GetCapabilities documents are cached (so no recalculation if
using FastCGI).<div class=""><br>
<br>
>Perhaps a different usage of spatialite driver between qgis
desktop and qgis-server ? <br>
<br></div>
QGIS server uses the public API, so it should be exactly the same
usage. Must be some other difference (libspatialite version?)<br>
<br>
Regards,<br>
Marco<div><div class="h5"><br>
<br>
On 13.02.2014 23:34, Andrea Peri wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>Hi, <br>
</div>
I partially resolved.<br>
<br>
</div>
The framework I sued will allow me bypass the
getcapabilities phase and go directly to the getmap
phase.<br>
</div>
Initizally also the getmap phase seem to be too slow,
but after some try I notice that a slow bottleneck is
the change of SRS.<br>
So fixing the SRS to the same of the dataset will gain
a bit of speed and now the time to wait is quite
acceptable.<br>
</div>
The strange is that the qgis desktop on my notebook ,
using the same project and the same datasets is more,
more speeder than my server where there is the
qgis-server.<br>
<br>
</div>
We use a spatialite db.<br>
</div>
Perhaps a different usage of spatialite driver between qgis
desktop and qgis-server ?<br>
Actually I don't know.<br>
</div>
<br>
</div>
<div>
<div>
<div>Regards,<br>
</div>
<div>Andrea.<br>
</div>
<div><br>
</div>
</div>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2014-02-13 11:30 GMT+01:00 Andrea Peri
<span dir="ltr"><<a href="mailto:aperi2007@gmail.com" target="_blank">aperi2007@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<p dir="ltr">Hi I'm trying to publish with qgis.server a
project with some huge dayaset. Actually the
getcapabilities tale about 40 sec to return. I suspect
that QS try always to recalc the box of every layer.<br>
Is confirmed that qgis.server recompute always the box for
every request ?<br>
If confirmed, There is an option to avoid this ? </p>
<p dir="ltr">THX,<br>
Andrea</p>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
-----------------<br>
Andrea Peri<br>
. . . . . . . . . <br>
qwerty àèìòù<br>
-----------------<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><div class=""><pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</div></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<br>
<pre cols="72">--
Dr. Marco Hugentobler
Sourcepole - Linux & Open Source Solutions
Weberstrasse 5, CH-8004 Zürich, Switzerland
<a href="mailto:marco.hugentobler@sourcepole.ch" target="_blank">marco.hugentobler@sourcepole.ch</a> <a href="http://www.sourcepole.ch" target="_blank">http://www.sourcepole.ch</a>
Technical Advisor QGIS Project Steering Committee </pre>
</font></span></div>
<br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br><br clear="all"><br>-- <br>-----------------<br>Andrea Peri<br>. . . . . . . . . <br>
qwerty àèìòù<br>-----------------<br>
</div>