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 wrote: > Chris > > something that came into my mind was the use of queryMap. I had not used > it since eternities because it became obsole

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 wo

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 displaye

[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) sl

Re: [pmapper-users] ThemesandViews error and search by user defined shape - pmapper version

2010-08-24 Thread Chris Jackson
Hi I am using version 4.0.0 (mmm... maybe the dev version from about 2 weeks ago), well to be thorough just enabled plugin in both verisons and the same error is reported - PM.Plugin.ThemesAndViews is undefined. Thanks Chris --

[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 one-to-