Hey Guys,
we are doing some performance testing right now qith our web service.
Therefore we send a normal HTTP Request over the Geoserver to the Database
and a standard JDBC Request direct to the Database. Afterwords I want
subtract the jdbc from the http to get the time the geoserver needs for
rendering and transfering the data.
What I need to know now is: Does Geoserver just open once a datbase
connection and holds this one or does Geoserver everytime start a new
connection and closes this one after a request? Because now the times are
better when the request goes threw geoserver...
Hope to get an answer of you.
thanks a lot. greetz andy.
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Geoserver-Connection-To-Database-tp5042894.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Hi Andras,
Have a look at
http://docs.geoserver.org/stable/en/user/data/database/connection-pooling.html
GeoServer does not open a new connection for each request, as in your
test case, so better performance are expected.
I am not sure but if you are using JMeter as testing tools you may
configure it to use pooled connetcion too.
Cheers,
Stefano
---------------------------------------------------
41.95581N 12.52854E
http://www.linkedin.com/in/stefanoiacovella
http://twitter.com/#!/Iacovellas
2013/3/26 Andreas100 <andreas.holzer@anonymised.com>:
Hey Guys,
we are doing some performance testing right now qith our web service.
Therefore we send a normal HTTP Request over the Geoserver to the Database
and a standard JDBC Request direct to the Database. Afterwords I want
subtract the jdbc from the http to get the time the geoserver needs for
rendering and transfering the data.
What I need to know now is: Does Geoserver just open once a datbase
connection and holds this one or does Geoserver everytime start a new
connection and closes this one after a request? Because now the times are
better when the request goes threw geoserver...
Hope to get an answer of you.
thanks a lot. greetz andy.
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Geoserver-Connection-To-Database-tp5042894.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game
on Steam. $5K grand prize plus 10 genre and skill prizes.
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
hey Stefano!
thanks a lot for helping me.
Yes I do use JMeter, where can i configure it?
greetz andy
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Geoserver-Connection-To-Database-tp5042894p5042913.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Connection_Configuration
---------------------------------------------------
41.95581N 12.52854E
http://www.linkedin.com/in/stefanoiacovella
http://twitter.com/#!/Iacovellas
2013/3/26 Andreas100 <andreas.holzer@anonymised.com>:
hey Stefano!
thanks a lot for helping me.
Yes I do use JMeter, where can i configure it?
greetz andy
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Geoserver-Connection-To-Database-tp5042894p5042913.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game
on Steam. $5K grand prize plus 10 genre and skill prizes.
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users