[Geoserver-users] Overworked CPU .. GeoServer & Oracle

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi all,

Please see below an email I sent to the uDig list which it appears may be
more relevant to this list.  In summary the issue is as follows:

I'm running uDig 1.1-RC10  Geoserver 1.5.? and Oracle 10.0.2.3 on my laptop
(2GB RAM, Intel core 2 duo CPU) and am testing viewing mastermap for an
entire UK county via WFS.  I have 3 layers loaded in uDig, topographic line,
which is all the lines on the map (there are 4.8 million in the complete
table but I'm only looking at one village in uDig at the moment, the points
which I extracted from topographic line (21 million points in the layer) and
a data layer which compared to the other two is inconsequential.

Initially when the layers are loaded it takes a minute or so for them to be
rendered but once they're there I can pan around and zoom with reasonable
speed, there's usually a second or so delay before a redraw but nothing
prohibitive.  The problem is that once uDig has loaded all the layers the
CPU continues to work hard for up to 15 minutes or so after the layers have
been loaded, with no panning or zooming, in fact with no user interaction at
all.  Closing uDig does not return the CPU to normal levels, closing
Geoserver immediately does so it looks like Geoserver and Oracle are the
culprits.  What's going on here?

Tom

---------- Forwarded message ----------
From: Jody Garnett <jga...@re...>
Date: Jul 26, 2007 1:51 AM
Subject: [udig-devel] Overworked CPU .. GeoServer
To: User-friendly Desktop Internet GIS <udi...@li...>

Thanks David for the helpful hint; indeed lets send this on to GeoServer
along with instructions on how to reproduce the problem.
Jody
> I don't have a profiler and I wouldn't know where to start so if
> that's reqd someone will have to guide me through it, however I tried
> David's suggestion and loaded uDig up with all my layers.  Once they
> had loaded I left it for a couple of minutes and as usual the CPU
> continued to work hard.  I then closed uDig and the CPU continued to
> work hard.  I left it for another couple of minutes or so and then
> shut down Geoserver at which point the CPU immediately dropped back to
> normal.  That suggests to me that the problem is with Geoserver and
> Oracle and not uDig so if you agree I'll forward this to the geoserver
> mailing list to see what they think?
>
> Tom
>
> On 7/25/07, *David Zwiers* < dav...@gm...
> <mailto:dav...@gm...>> wrote:
>
>     Rather than using a profiler (can be hard to setup because eclipse
>     is an exe and there are two pids here), you may be able to
>     issolate the issue by replicating, then killing uDig but not
>     geoserver. If the CPU returns to normal, I would be inclined to
>     think this is an issue between uDig and GeoServer (having little
>     or nothing todo with Oracle).
>
>     My 2 cents
>     David
>
>
>     On 7/25/07, *Jody Garnett* <jga...@re...
>     <mailto:jga...@re...>> wrote:
>
>         Tom (JDi Solutions) wrote:
>         > but the CPU is maxed out for 15 minutes or so after the layer
>         has been
>         > rendered, without me zooming or panning.  Why?  Presumably
>         uDig only
>         > requests the data it needs to render the area of the layer
>         shown on
>         > screen, so what is the CPU working on for the next 15 minutes
>         while I
>         > do nothing?
>         You are correct that sounds wrong :-(
>
>         Sounds like we need to get you to run in a profiler so we can
>         tell what
>         the matter is (sigh). Do you have a profiler available?
>
>         Jody
>         _______________________________________________
>         User-friendly Desktop Internet GIS (uDig)
>         http://udig.refractions.net <http://udig.refractions.net/>
>         http://lists.refractions.net/mailman/listinfo/udig-devel
>         <http://lists.refractions.net/mailman/listinfo/udig-devel>
>
>
>
>     _______________________________________________
>     User-friendly Desktop Internet GIS (uDig)
>     http://udig.refractions.net
>     http://lists.refractions.net/mailman/listinfo/udig-devel
>     <http://lists.refractions.net/mailman/listinfo/udig-devel >
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
>

_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel