Momentarily we are trying to switch from our current GIS server to
Geoserver and while comparing the two I noticed some performence issues.
When executing a GetMap request for a single (256x256) tile with a Oracle
datastore there is a 3-4 second delay which is shown in the log. This is
before the actual query is executed and I don't see why this delay is
there. The rest of the image creation is done in milliseconds. These 3-4
seconds is between a CREATE CONNECTION and CLOSE CONNECTION:
08:41:03,819 INFO [STDOUT] 24 jan 08:41:03 INFO [org.geoserver.wms] -
Request: getServiceInfo
08:41:03,833 INFO [STDOUT] 24 jan 08:41:03 DEBUG [org.geotools.styling] -
number of fts set 1
08:41:03,845 INFO [STDOUT] 24 jan 08:41:03 DEBUG [org.geotools.jdbc] -
CREATE CONNECTION <-----------------------
08:41:07,229 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.jdbc] -
CLOSE CONNECTION <-----------------------
08:41:07,236 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.styling] -
number of fts set 1
08:41:07,242 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.rendering]
- Computed scale denominator: 3779.759863681462
08:41:07,248 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.styling] -
number of fts set 1
08:41:07,254 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.rendering]
- processing 1 stylers for...
08:41:07,259 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.rendering]
- creating rules for scale denominator - 3.779,76
08:41:07,265 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.styling] -
creating defaultMark
08:41:07,271 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.styling] -
creating defaultMark
08:41:07,276 INFO [STDOUT] 24 jan 08:41:07 TRACE [org.geotools.styling] -
ENTRY
08:41:07,282 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.styling] -
creating defaultMark
08:41:07,287 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.rendering]
- Expanding rendering area by 4 pixels to consider stroke width
08:41:07,292 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.rendering]
- Querying layer ...
08:41:07,304 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.jdbc] -
CREATE CONNECTION
08:41:07,308 INFO [STDOUT] 24 jan 08:41:07 TRACE [org.geotools.core] -
ENTRY 4
08:41:07,313 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.filter] -
exporting PropertyName
08:41:07,318 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.jdbc] - ...
08:41:07,324 INFO [STDOUT] 24 jan 08:41:07 DEBUG
[org.geotools.data.oracle.sdo] - Using layer SRID: 90112
08:41:07,329 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.jdbc] -
Setting parameter 1 as MDSYS.SDO_GEOMETRY(2003,90112,NULL,MDSYS.SDO_ELEM_
08:41:07,334 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.jdbc] - 1 =
POLYGON ((98287.00731434968 439283.53962355264, 98287.00731434968 439
08:41:07,347 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.rendering]
- trying to render symbol square
08:41:07,352 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.rendering]
- rendering mark @ PointRenderer square
08:41:07,358 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.rendering]
- fetching mark of name square
08:41:07,362 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.rendering]
- returning square
08:41:07,390 INFO [STDOUT] 24 jan 08:41:07 DEBUG [org.geotools.jdbc] -
CLOSE CONNECTION
Is this something that can be optimized in any way? It would make the
request alot faster.
Best regards.
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
