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 > [email protected] > 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 [email protected] 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 _______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
