Steve<br><br>The selection of layer data is done by a bounding box, though querying by parameter values is just as slow. The mapfile is directly calling up the shapefile (I had just followed the P.Mapper examples of displaying/querying shapefiles directly). So probably the answers to those questions lie under the hood of P.Mapper, which I assume is using the PHP mapscript.dll to do the work. Is the direct query to shapefile approach v.efficient for larger datasets..?. Ignoring the app I am using what is a good approach to large feature datasets from a MapServer perspective?<br>
<br>Thanks<br>Chris<br><br><br><br><div class="gmail_quote">On 24 August 2010 14:27, Lime, Steve D (DNR) <span dir="ltr"><<a href="mailto:Steve.Lime@state.mn.us" target="_blank">Steve.Lime@state.mn.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">How is the selection done? How is the highlighting done? Those processes will really impact performance depending on how things are implemented.<br>
<br>
Steve<br>
<br>
________________________________________<br>
From: <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a> [<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>] On Behalf Of Chris Jackson [<a href="mailto:webturtles@gmail.com" target="_blank">webturtles@gmail.com</a>]<br>
Sent: Tuesday, August 24, 2010 3:19 AM<br>
To: <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
Subject: [mapserver-users] Feature select performance<br>
<div><div></div><div><br>
Hi all<br>
<br>
I have rigged up a webGIS app (P.Mapper framework) where one of the underlying datasets is a model grid (many thousand cells) in a shapefile. The data displays nice and quick when just viewing, but if I allow the user to select say 5000 cells it is very (extremely) slow to redraw with the highlighted cells. Doing the same task in a very old ArcGIS server web app was much quicker (admittedly the data was in SDE/MS SQL). So my question is what is the best way to improve performance - would just transferring the shapefile to to say a MS SQL 2005 db with the MSSQLSPATIAL add-on be a good step or is there are better way to present the data in the Map file?<br>
Many thanks<br>
Chris<br>
</div></div></blockquote></div><br>