[pmapper-users] Attribute search example with MySQL table

2010-08-24 Thread Dejan Gambin
Hi, I have successfully made a join from shape file to MySQL database using RESULT_JOIN syntax like this: RESULT_JOIN mysql://user:pas...@localhost/database_name||table_n...@table_join_field@1...@name,owner||SHAPE_JOIN_FIELD||1 I have also slightly modified sqery.php so that

[pmapper-users] Feature select performance

2010-08-24 Thread Chris Jackson
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)

Re: [pmapper-users] Feature select performance

2010-08-24 Thread Armin Burger
Chris the way the highlight works, is taking all shape features' ID's and adding one by one to a temporary dynamic layer, using a Mapscript function addFeature(). This is for sure not an efficient way but has no problems for normal selections up to a few 100's. Having a result table displayed

Re: [pmapper-users] Feature select performance

2010-08-24 Thread Armin Burger
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

Re: [pmapper-users] Feature select performance

2010-08-24 Thread Chris Jackson
Armin Thanks for racking your brains on this, sounds promising and will give it a go tomorrow. Much appreciated. Chris On 24 August 2010 21:43, Armin Burger armin.bur...@gmail.com wrote: Chris something that came into my mind was the use of queryMap. I had not used it since eternities