The first important bottleneck is reprojection, obviously.<div>Removing the reprojection from 23032 to 900913, the time is dropped from 7.2s to 4.6s.</div><div><br></div><div>I go on...</div><div><br></div><div>giovanni<br>
<br><div class="gmail_quote">2012/6/28 G. Allegri <span dir="ltr"><<a href="mailto:giohappy@gmail.com" target="_blank">giohappy@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I will go on testing.<div>In the meantime, the same exact shp2img command run on Linux gives much better performances, and OGR outperforms POSTGIS again.</div><div><br></div><div>Windows</div><div>POSTGIS: 7.2s</div><div>
OGR: 2.7s</div>
<div><br></div><div>Linux</div><div>POSTGIS: 2.5s</div><div>OGR: 1.0s</div><div><br></div><div>giovanni</div><div class="HOEnZb"><div class="h5"><div><br><div class="gmail_quote">2012/6/28 Jeff McKenna <span dir="ltr"><<a href="mailto:jmckenna@gatewaygeomatics.com" target="_blank">jmckenna@gatewaygeomatics.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">And how did another small polygon file do? (it could be a problem with<br>
your one table)<br>
<span><font color="#888888"><br>
-jeff<br>
</font></span><div><br>
<br>
> - load another small polygon shapefile into your PG, then try that with<br>
> MapServer<br>
><br>
<br>
<br>
</div><div><div>--<br>
Jeff McKenna<br>
MapServer Consulting and Training Services<br>
<a href="http://www.gatewaygeomatics.com/" target="_blank">http://www.gatewaygeomatics.com/</a><br>
<br>
<br>
<br>
_______________________________________________<br>
MS4W-Users mailing list<br>
<a href="mailto:MS4W-Users@lists.maptools.org" target="_blank">MS4W-Users@lists.maptools.org</a><br>
<a href="http://lists.maptools.org/mailman/listinfo/ms4w-users" target="_blank">http://lists.maptools.org/mailman/listinfo/ms4w-users</a><br>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>