On Fri, Aug 17, 2012 at 7:21 PM, cheesybiscuits
<[email protected]>wrote:
> - Oracle receives a very basic query from GeoServer. Returning a result
> takes around 2.5 seconds (there could be separate Oracle performance issues
> here that need addressing, but for now I want to focus on GeoServer).
> - GeoServer seems to ask for the results in batches of 200 (Oracle reports
> 600+ occurences of waiting for instructions from the client) and renders
> each feature as it comes back.
>
GeoServer sets the fetch size to whatever you configured in the datastore
configuration panel.
I believe the default is 1000 though, it's odd that you see 200.
> - After the Oracle query completes GeoServer takes 5 seconds to request and
> draw 130,000 features with default red square.
>
> 5 seconds seems like a long time for 130,000 features with very basic
> styling. Does this indicate a problem?
>
Difficult to say. Is the point symbolizer the only thing you have in the
style?
No text symbolizers for example?
What version of GeoServer are you using?
>
> I am yet to really dig into resource usage but I think I saw that Java was
> consuming several GB of memory, which I think pushes it into swap space and
> I know this will slow things down. Is it reasonable for Java to use so much
> memory for such simple rendering?
>
GeoServer (almost) never loads all the data into memory, there are two
threads connected
by a blocking queue, one constantly fetches data and pre-processes it, the
other
renders it (the only exception is labels, those we need to keep in memory
to
deal with label priorities and conflict resolution).
Java memory management might however trump you, as the JVM gets the memory
it needs up to the maximum configured size, and almost never releases it,
so memory consumption normally reaches a limit after some time and stops
growing.
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
