Re: [Geoserver-users] Oracle NG Datastore, connection timeout and fetch size

[Andrea A. <aa...@op...>]

2StepForward ha scritto:
> Hello List,
> 
> I have a question about two new Oracle NG Datastore properties where I
> didn,t find documentation.
> 
> In the new Oracle NG Datastore there are the connection timeout property.
> What kind of units there will be used? I think milliseconds but I'm not
> realy sure about it.
> And what is the meening of connection timeout? The timeout to get a
> connection to the Oracle DB?

Yes, but the unit is seconds, not milliseconds.

> Secound is the fetch size property.
> There I have the same questions. What kind of units will be used there? I
> think kb.
> And what is the meening of fetch size? The size in kb which will be posted
> from the geoserver to the DB?

Nope, it's the number of records that will be pulled in one network
transfer from Oracle to GeoServer while reading.
Too low (less than 50) and you'll suffer from network latency, too high
and you risk pushing GeoServer towards an out of memory error because it
will have to keep that batch of records in memory while turning them
into GeoTools features that can be used in the rest of the GeoServer
processing chain.

I've updated the documentation accordingly, you'll be able to find
it in tomorrow's nightly build of the docs
(http://gridlock.openplans.org/geoserver/1.7.x/doc/)

Cheers
Andrea

-- 
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.