On 04/28/2012 14:44, Matt McClelland wrote:
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.
are you sure your postgresql is well configured ? can you pastebin your
postgresql.conf and some details about your configuration ?
Any ideas on how to make it faster.
Thanks
Matt :)
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
