Re: [mapserver-users] Strange performance problem in mapserver

[ahlah]

s.notice_radius is also 750.



--
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

Re: [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 
 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
  , 
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  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Strange performance problem in mapserver

[ahlah]

As I told I copied both Postgis queries from logs to pgAdmin and ran them
without MapServer.  Both took about 200ms. So it seems that bottleneck is in
Mapserver.



--
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

Re: [mapserver-users] Strange performance problem in mapserver

[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
>   , 
> 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
> 


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.thom...@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
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Strange performance problem in mapserver

[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
  , 
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