I try to show a polygon on map by creating a buffer around point in Postgis (by ST_Buffer) but Mapserver has a strange performance problem. If I put hardcoded radius to ST_Buffer query, rendering takes about 10 seconds although query result is empty. If I set the same value to radius by reading it from another db table, rendering takes only 300ms. Attached logs clarifies the sequences: map_slow.log <http://osgeo-org.1560.x6.nabble.com/file/t202655/map_slow.log> , map_fast.log <http://osgeo-org.1560.x6.nabble.com/file/t202655/map_fast.log> Problem is not in Postgis because both queries takes about 200ms if I run them on pgAdmin. Am I doing something wrong or is it a bug or feature in MapServer? I have tested it in MapServer 5 and MapServer 7 and result is same.
-- Sent from: http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users