[mapserver-users] Displaying Huge Data on Mapserver

[Simon Haddon]

I have had a postgresql / postgis database with over 120 million rows of 
point data in a single table and I have been amazed about how well 
postgresql performs.  As long as you get your indexes and queries right 
then I would recommend that option for point data.

Cheers,
Simon

Frank Warmerdam wrote:
> Rishikant Lal wrote:
>> Dear Friends,
>> I need some help. I have a Point Feature Layer that I want to display 
>> on Map Server. The layer has Nearly Ten Million Point Features.
>
> Rishikant,
>
> This is not a terribly large database though it is certainly large enough
> that care must be taken in how it is accessed.
>
>> What kind of Data Base should I use?
>> Will Post GIS support this kind of Data?
>> What are the steps I should use to speed up the Map Display Process?
>
> You should be able to achieve good performance with tile indexed 
> shapefiles
> with indexes on the individual shapefiles and the tileindex.  Some
> experimentation might be required to find an optimal breakdown.  You 
> could
> *try* it in one big shapefile with a spatial index but I have some doubts
> about whether this would give ideal performance.
>
> This dataset could also be well handled in PostGIS with a spatial index
> on the geometry column of course.
>
> A lot depends on what you want to do with this dataset of course.  I'm 
> assuming
> you want to render maps of very local regions with only a few 
> thousands of
> points.  Rendering points as symbols or labels can be expensive so we 
> wary
> of trying to render too many on a map.
>
> Best regards,