[MS4W-Users] slow access to PostGIS layer
giohappy at gmail.com
Thu Jun 28 09:45:11 EST 2012
The first important bottleneck is reprojection, obviously.
Removing the reprojection from 23032 to 900913, the time is dropped from
7.2s to 4.6s.
I go on...
2012/6/28 G. Allegri <giohappy at gmail.com>
> I will go on testing.
> In the meantime, the same exact shp2img command run on Linux gives much
> better performances, and OGR outperforms POSTGIS again.
> POSTGIS: 7.2s
> OGR: 2.7s
> POSTGIS: 2.5s
> OGR: 1.0s
> 2012/6/28 Jeff McKenna <jmckenna at gatewaygeomatics.com>
>> And how did another small polygon file do? (it could be a problem with
>> your one table)
>> > - load another small polygon shapefile into your PG, then try that
>> > MapServer
>> Jeff McKenna
>> MapServer Consulting and Training Services
>> MS4W-Users mailing list
>> MS4W-Users at lists.maptools.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the MS4W-Users