Echoing Andrea, I will often estimate the extent separately and type it in
manually on large datasets (>4GB).
Best,
Steve
[http://sig.cmparks.net/cmp-ms-90x122.png] Stephen V. Mather
GIS Manager
(216) 635-3243 (Work)
clevelandmetroparks.com<http://www.clemetparks.com>
________________________________
From: Andrea Aime [[email protected]]
Sent: Wednesday, February 20, 2013 11:38 AM
To: [email protected]
Cc: [email protected]
Subject: Re: [Geoserver-users] calculating MBR
On Wed, Feb 20, 2013 at 5:10 PM,
[email protected]<mailto:[email protected]>
<[email protected]<mailto:[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
