Chris something that came into my mind was the use of queryMap. I had not used it since eternities because it became obsolete to me using the p.mapper highlighting method. I made a quick test and it would need just a few lines in query.php and map.php to change/add.
Note that this will only work for selects, not identifies or searches (this would require some more changes). And I have currently no plans for changing to this solution, it might be faster in case of lots returned values, but has less flexibility. And it would not work with the current way of searching in Postgis layers. If you're interested, I put the files at http://www.pmapper.net/dl/querymap.zip You need to define a querymap entry in the map file like QUERYMAP COLOR 255 255 0 STATUS on STYLE hilite END also set <highlightSelected> in the XML config file to 0. I have not modified anything to remove the highlight but I can tell you what to modify in case you would like to use this solution. armin On 24/08/2010 16:58, Chris Jackson wrote: > Hi all > > One of the underlying datasets in my P.Mapper app 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 (using the select > by rectangle tool or even the seach tool) 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? Does using a > shapefile just not cut it when selecting so much data? Has anyone got > P.Mapper to work with a mapfile containing a layer where the data is within > a MS SQL 2005 db with the MSSQLSPATIAL add-on (using OGR)? Or are there > other better approaches to use or settings (inc. PHP) to tweak? > > Many thanks > Chris > ------------------------------------------------------------------------------ > Sell apps to millions through the Intel(R) Atom(Tm) Developer Program > Be part of this innovative community and reach millions of netbook users > worldwide. Take advantage of special opportunities to increase revenue and > speed time-to-market. Join now, and jumpstart your future. > http://p.sf.net/sfu/intel-atom-d2d > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------------ Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users