[mapserver-users] Strange performance problem in mapserver

[Jörg Thomsen (WhereGroup)]

Hi ahti,
are you sure it si not postgis? Using the fixed radius it takes 10
seconds, with the radius from the other table it takes < 1 second until
mapserver gets the result, have a look at line 16 and 17 of your logs:

> [Tue Sep  4 14:39:39 2018].545070 msPostGISLayerWhichShapes query: ... 
> [Tue Sep  4 14:39:39 2018].801153 msPostGISLayerWhichShapes query ... 

and

> [Tue Sep  4 14:29:06 2018].418047 msPostGISLayerWhichShapes query: ... > [Tue Sep  4 14:29:17 2018].162168 msPostGISLayerWhichShapes query ...

I would compare the database-queries in line 16 in PostGIS to be sure
wether the bottleneck is MapServer or PG.

Jörg




Am 04.09.2018 um 14:50 schrieb ahlah:
> 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
> 


Viele Grüße,
Jörg Thomsen

-- 

******************************************************************
 FOSS Academy Sommerschule 2018
 Alles Wichtige zur Erstellung einer GDI in nur 5 Tagen erlernen!
 https://www.foss-academy.com/kompaktkurse
 *****************************************************************


Jörg Thomsen
WhereGroup GmbH & Co. KG
Gillweg 3
14193 Berlin
Germany

Fon: +49 (0)30 / 5130 278 74
Fax: +49 (0)30 / 89 09 53 21

joerg.thomsen at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------
Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com