<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
On 04/28/2012 14:44, Matt McClelland wrote:
<blockquote
cite="mid:CAGbhREn1_9TfOjh-8jeu-0Y5BS01ApuwBo78wuE-PTFpZhOYtQ@mail.gmail.com"
type="cite">Hi All<br>
<br>
I have a set of contours in a SHP file<br>
If I point my map file to the SHP file I can generate a WMS image
in under 1 second<br>
Shp file is just shy of 200MB<br>
<br>
I then use shp2pgsql to load the same dataset into the DB<br>
I added an index for the_geom<br>
And am requesting the data in the mapfile using the same EPSG<br>
<br>
The map draws correclty but is now taking about 30secs when using
the DB.<br>
<br>
</blockquote>
<br>
are you sure your postgresql is well configured ? can you pastebin
your postgresql.conf and some details about your configuration ?<br>
<br>
<blockquote
cite="mid:CAGbhREn1_9TfOjh-8jeu-0Y5BS01ApuwBo78wuE-PTFpZhOYtQ@mail.gmail.com"
type="cite">Any ideas on how to make it faster.<br>
<br>
Thanks<br>
<br clear="all">
Matt :)<br>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</pre>
</blockquote>
<br>
</body>
</html>