[mapserver-users] Displaying Huge Data on Mapserver

[Rishikant Lal]

Dear Friends,
I have a problem. I am trying to display nearly 10 Million Rows of Point
feature on Map Server. I have imported the Data on Post GIS, Created
GistIndex and even used Fast CGI. Features Display very quickly without
Labels. Problem occurs if I try to label them in Layer definition.
Is there a way I can Label Features in MapServer, without affecting the Map
Display Speed.

Thanks in Advance
Rishikant


On Thu, Aug 20, 2009 at 2:27 AM, Simon Haddon <simon at sibern.com.au> wrote:

> 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,
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090821/4561942b/attachment.html