Yet,
it is a heavy job to do this calculation because it does a full table scan
instead to use the spatial index in Oracle.
2013/2/20 Andrea Aime <[email protected]>
> On Wed, Feb 20, 2013 at 5:10 PM, [email protected] <
> [email protected]> 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
>
> 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 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> -------------------------------------------------------
>
--
Mauro Bagazzi
SardegnaIT srl
Viale Trieste 186, Cagliari
Telefono : +39-0706064365
E-mail: <[email protected]>
Skype: mauro.bagazzi
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
