<div>Dear Friends,</div>
<div>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.</div>
<div>Is there a way I can Label Features in MapServer, without affecting the Map Display Speed.</div>
<div> </div>
<div>Thanks in Advance</div>
<div>Rishikant</div><br><br>
<div class="gmail_quote">On Thu, Aug 20, 2009 at 2:27 AM, Simon Haddon <span dir="ltr"><<a href="mailto:simon@sibern.com.au">simon@sibern.com.au</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">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.<br>
<br>Cheers,<br><font color="#888888">Simon</font>
<div>
<div></div>
<div class="h5"><br><br>Frank Warmerdam wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Rishikant Lal wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Dear Friends,<br>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.<br>
</blockquote><br>Rishikant,<br><br>This is not a terribly large database though it is certainly large enough<br>that care must be taken in how it is accessed.<br><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">What kind of Data Base should I use?<br>Will Post GIS support this kind of Data?<br>What are the steps I should use to speed up the Map Display Process?<br>
</blockquote><br>You should be able to achieve good performance with tile indexed shapefiles<br>with indexes on the individual shapefiles and the tileindex. Some<br>experimentation might be required to find an optimal breakdown. You could<br>
*try* it in one big shapefile with a spatial index but I have some doubts<br>about whether this would give ideal performance.<br><br>This dataset could also be well handled in PostGIS with a spatial index<br>on the geometry column of course.<br>
<br>A lot depends on what you want to do with this dataset of course. I'm assuming<br>you want to render maps of very local regions with only a few thousands of<br>points. Rendering points as symbols or labels can be expensive so we wary<br>
of trying to render too many on a map.<br><br>Best regards,<br></blockquote><br></div></div></blockquote></div><br>