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
-------------------------------------------------------
------------------------------------------------------------------------------
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
