[mapserver-users] Speed of PostGIS vs Shapefiles in MapServer 5.4

ritesh ambastha ritesh.linux at gmail.com
Fri May 15 13:26:54 EDT 2009


Hey, 

The game is all about how you utilizes the best available practices. No
doubt that shapefile usage helps you to render/tile maps at a rapid pace.
But, on the other hand, indexing helps a ton on postgis. My recommendation
is to set up pgpool on few servers and then try to render/tile the maps. It
will be much much faster and convenient than using shapefiles. 

Regards,
Ritesh Ambastha

Regards,
Ritesh Ambastha

Ben Madin wrote:
> 
> G'day all,
> 
> I see a rewrite of PostGIS handling was a major achievement in the 5.4  
> Release. I have a number of polygon layers that I use on a fairly  
> static basis (political boundaries etc) but I vaccilate between using  
> them from:
> 
> PostGIS (for convenience - I use them for analysis as well so they are  
> in the database anyway, easy to backup and keep consistent between  
> servers) or from
> Shapefiles (exported because they were faster to render).
> 
> Most of them are not overly complex or large, is there still  
> significant benefit to using them from shapefiles, or is it becoming a  
> more closely run race between sources.
> 
> cheers
> 
> Ben
> 
> 
> -- 
> 
> Ben Madin
> REMOTE INFORMATION
> 
> t : +61 8 9192 5455
> f : +61 8 9192 5535
> m : 0448 887 220
> Broome   WA   6725
> 
> ben at remoteinformation.com.au
> 
> 
> 
> 							Out here, it pays to know...
> 
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Speed-of-PostGIS-vs-Shapefiles-in-MapServer-5.4-tp2843363p2908992.html
Sent from the Mapserver - User mailing list archive at Nabble.com.



More information about the mapserver-users mailing list