Oracle DB DataStore may be also the cause of bad performances.
I personally experienced a big loss of perfomances when using Oracle DB
vector layers.
Don't remember if GeoServer 2.0.2 use GeoTools JDBC DataStores with prepared
statements, as far as I remember some improvements have been done on this
recently.
Anyway, it would be possible for you to perform some similar tests using a
shapefile layer for instance in order to understand if the issue depends on
Oracle DataStore?
-------------------------------------------------------
Ing. Alessio Fabiani
Founder / CTO GeoSolutions S.A.S.
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: (+39) 0584 96.23.13
fax: (+39) 0584 96.23.13
mobile:(+39) 349 82.27.000
http://www.geo-solutions.it
http://geo-solutions.blogspot.com
http://www.linkedin.com/in/alessiofabiani
http://twitter.com/simogeo
-------------------------------------------------------
On Tue, Oct 5, 2010 at 12:39 PM, DGis <[email protected]> wrote:
>
> We are testing with five Oracle DB vector layers. The Oracle DB version is
> 10g. Layers have between 8 geometries (Polygon) and 180 millions of
> geometries (Point).
>
>
> Thanks
>
>
> Alessio Fabiani-2 wrote:
> >
> > Hi,
> >
> > looking at your feedbacks I kindly suggest a profiling session of
> > GeoServer
> > in order to better understand where is the memory lack.
> >
> > I suspet a misconfiguration of the garbage collector.
> >
> > Also what kind of vector layers are you loading? Shapefiles? DB? in case
> > of
> > DB which one?
> >
> > Regards,
> > Alessio.
> >
> > On Tue, Oct 5, 2010 at 11:46 AM, DGis <[email protected]>
> wrote:
> >>
> >> mcr wrote:
> >> >
> >> > Scanning over your error messages indicates the reason of your memory
> >> > problem
> >> >
> >> > First, your java parameters
> >> >
> >> > -Xms1024m -Xmx1024m
> >> >
> >> > Your java vm will allocate 1GB main memory for the heap, independent
> >> > how much heap memory is needed. The error occurred in the native
> >> > C/C++ code, reading a png image.
> >> >
> >> > The whole java process is consuming to much memory.
> >> >
> >> > 1)
> >> > Adjust your java parameters to
> >> >
> >> > -Xms128m -Xmx1024m.
> >> >
> >> > As a consequence, java will give back memory to your operating system
> >> > if the memory is not needed.
> >> >
> >> > 2)
> >> > What is the user/owner of the running java process. Is it root or
> >> > another user ? Anyway, make a
> >> >
> >> > su - username
> >> > ulimit -a
> >> >
> >> > and look for a line like
> >> >
> >> > max memory size (kbytes, -m) 2617064
> >> >
> >> > 3) How much main memory is installed in your servers.
> >> >
> >> > Cheers
> >> >
> >>
> >> Hi Christian,
> >>
> >> We have tested with -Xms128m -Xmx1024m and it crashes too.
> >>
> >> The user hasn't memory limit and the servers have near of 4GB of
> >> available
> >> memory.
> >>
> >> Thanks
> >
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/Doubt-about-Geoserver-performance-tp29856704p29886194.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
>
>
> ------------------------------------------------------------------------------
> Beautiful is writing same markup. Internet Explorer 9 supports
> standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
> Spend less time writing and rewriting code and more time creating great
> experiences on the web. Be a part of the beta today.
> http://p.sf.net/sfu/beautyoftheweb
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
