Re: [Geoserver-users] calculating MBR

[Stefano I. <ste...@gm...>]

2013/2/20 Andrea Aime <and...@ge...>:
> On Wed, Feb 20, 2013 at 5:10 PM, mba...@sa...
> <mau...@gm...> wrote:
>>
>> Hello everybody,
>>
>> is there a method to record somewhere in geoserver the result of the
>> following query executend on a Oracle DB ?
>>
>> SELECT SDO_AGGR_MBR(SHAPE) as boundingbox from DBMCOLTUREAGRICOLE
>>
>
> What do you mean record? Cache?
>
> The request is normally run only when you configure the layer and ask for
> teh native bbox to be computed,
> and can take a lot of time indeed.
> If you have a view indeed there is no faster way, but you can specify the
> bounds manually
> if you know them

I thougth that values were extracted from all_sdo_geom_metadata , but
there should be a good reason not to do that.
Would it be a problem having an extent not equal to real extent of all
features in the featuretype?

As usual thanks a lot for you patience and expertise

Stefano