[MS4W-Users] slow access to PostGIS layer

G. Allegri 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...

giovanni

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.
>
> Windows
> POSTGIS: 7.2s
> OGR: 2.7s
>
> Linux
> POSTGIS: 2.5s
> OGR: 1.0s
>
> giovanni
>
> 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)
>>
>> -jeff
>>
>>
>> >     - load another small polygon shapefile into your PG, then try that
>> with
>> >     MapServer
>> >
>>
>>
>> --
>> Jeff McKenna
>> MapServer Consulting and Training Services
>> http://www.gatewaygeomatics.com/
>>
>>
>>
>> _______________________________________________
>> MS4W-Users mailing list
>> MS4W-Users at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/ms4w-users
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/ms4w-users/attachments/20120628/db5ec839/attachment.htm 


More information about the MS4W-Users mailing list