POSTGIS vs Shapefile mapserver optimization

[Aaron Koning]

Also, OGR can be used to spatially index a shapefile (command: shptree),
which enables faster shapefile rendering in Mapserver.
     http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?ShpTree
     http://ogr.maptools.org/drv_shapefile.html

Aaron

On 12/12/06, Gregor Mosheh <gregor at hostgis.com> wrote:
>
> > Ask for the details you need to help me if you need some more ...
>
> Actually, it's usually the other way around. ;)
>
>
> > What is the better way to get mapserver generating map faster !
> > Is POSTGIS optimizing the way that mapserver build the map ?
>
> Typically, shapefiles are faster; or at least that's what I've
> consistently been told is true for the majority of cases.
>
> If your PostGIS performance is slow, make sure you have indexes! Nothing
> affects performance as much as indexes, and they're an easy thing to
> forget to do. Ensure that there's a GiST index on your geometry column, as
> well as on on your oid column. If the indexes are missing, generate them
> as follows:
>
>    create index tablename_the_geom on tablename (the_geom) using gist;
>    create index tablename_oid on tablename (oid);
>    analyze tablename;
>



-- 
+-------------------------------------------------
|  Aaron Koning
|  Information Technologist
|  Prince George, BC, Canada.
+-------------------------------------------------
|  Flexible Internet Spatial Template:
|       http://fist-mapping.org
+-------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061212/187a0bf0/attachment.htm>