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 > > [email protected] > > > > Out here, it pays to > know... > > > _______________________________________________ > mapserver-users mailing list > [email protected] > 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. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
