[mapserver-users] Really slow map creation from POSTGIS DB

[Matt McClelland]

Hi All

I have a set of contours in a SHP file
If I point my map file to the SHP file I can generate a WMS image in under
1 second
Shp file is just shy of 200MB

I then use shp2pgsql to load the same dataset into the DB
I added an index for the_geom
And am requesting the data in the mapfile using the same EPSG

The map draws correclty but is now taking about 30secs when using the DB.

Any ideas on how to make it faster.

Thanks

Matt  :)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120428/44147ec0/attachment.htm>