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

2012-04-28 Thread Julien Cigar
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 A

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

2012-04-28 Thread Stephen Woodbridge
On 4/28/2012 9:44 AM, Puneet Kishor wrote: On Apr 28, 2012, at 8:20 AM, Stephen Woodbridge wrote: On 4/28/2012 8:44 AM, 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 sh

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

2012-04-28 Thread Puneet Kishor
On Apr 28, 2012, at 8:20 AM, Stephen Woodbridge wrote: > On 4/28/2012 8:44 AM, 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 us

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

2012-04-28 Thread Stephen Woodbridge
On 4/28/2012 8:44 AM, 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 An

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

2012-04-28 Thread 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 t