Developer Discussions

Discuss topics with other Hexagon Geospatial Power Portfolio developers and experts to get the most out of our products.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 46
Registered: ‎02-16-2017

WebMap: 'calling check connections' performance issues

I noticed that if WebMap idles for some time, the next time a MapSvr.exe is requested, the initialization of the MapSvr is very slow: 

 

 

GeoMedia Web Map Version 16.00.0200.00004

2017-09-11 10:09:16 (0.000025) - Process ID 8968
2017-09-11 10:09:16 (0.000414) - Q:0  T:0
2017-09-11 10:09:16 (0.000449) - calling check connections
2017-09-11 10:09:16 (0.000499) - number of library connections to check 2
2017-09-11 10:09:16 (0.000861) - check query select ID from LibraryGeneralProps where 0=1
2017-09-11 10:09:16 (0.006516) - Query result 0(0)
2017-09-11 10:09:16 (0.006761) - check query select ID from LibraryGeneralProps where 0=1
2017-09-11 10:09:16 (0.021679) - Query result 0(0)
2017-09-11 10:10:28 (71.968296) - Closing OPs
2017-09-11 10:10:28 (71.968726) - OPs closed
2017-09-11 10:10:28 (71.968737) - Logo Font Size in Clear 0.000000

It is actually faster to restart the WebMap Service instead of waiting until all MapSvr.exes have done that mysterious library connection check. Can someone explain that behavior? What is going on between 'Query result 0(0)' and 'Closing OPs'?

 

Without idle time or after a service restart:

 

GeoMedia Web Map Version 16.00.0200.00004

2017-09-11 10:22:21 (0.000006) - Process ID 7708
2017-09-11 10:22:21 (0.000076) - Q:0  T:0
2017-09-11 10:22:21 (0.000100) - calling check connections
2017-09-11 10:22:21 (0.000117) - number of library connections to check 2
2017-09-11 10:22:21 (0.000148) - check query select ID from LibraryGeneralProps where 0=1
2017-09-11 10:22:21 (0.001431) - Query result 0(0)
2017-09-11 10:22:21 (0.001531) - check query select ID from LibraryGeneralProps where 0=1
2017-09-11 10:22:21 (0.015773) - Query result 0(0)
2017-09-11 10:22:22 (0.280730) - Closing OPs
2017-09-11 10:22:22 (0.280841) - OPs closed

 

Christian Venzin
Software Engineer
Hexagon Safety & Infrastructure
Highlighted
Staff
Posts: 296
Registered: ‎11-05-2015

Re: WebMap: 'calling check connections' performance issues

The check connection logic on the initialization of the MapSvr is actually two fold and consists of a library connections check/reconnect and a warehouse connections check/reconnect. The latter is actually happening between the two lines you mentioned.

 

Quite possibly, after idling for too long, the warehouse connection (or many of them) has been dropped and the check gets into a timeout condition instead of learning the status of the connection off the bat. That's why it's taking longer than simply re-establishing the connection you get when you start with a fresh Map Server.