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