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