[mapserver-users] Strange performance problem in mapserver

[Carlos Ruiz]

Ahlah,
Mapserver does the following that should take some additional time:encode(ST_AsBinary(ST_Force_2D("point"),'NDR'),'hex') as geomYou can execute the whole query in PostgreSQL and notice the increase of time.
One question: s.notice_radius FROM (SELECT * FROM roronline.settings LIMIT 1) AS sis equal to 750 ? or is it smaller ?
It is a good practice to sort the query before apply a limit.

Cheers,
https://www.linkedin.com/in/cruizch
    On Tuesday, September 4, 2018, 7:50:39 AM CDT, ahlah <ahti.lahtela at pp.inet.fi> wrote:  
 
 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 at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20180905/d135a816/attachment.html>