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

[Steve Lime]

The PostGIS rewrite was more about maintainability than speed. In fact, the new code 
is a touch slower although probably not significantly so. If you're really trying to crank
as much performance out as possible then in many cases shapefiles will win. Convenience
should not be overlooked though so why bother with multiple versions of the same data
if you can live with a few milleseconds slower.

Steve

>>> Ben Madin <ben at remoteinformation.com.au> 05/07/09 10:14 PM >>>
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