Jonathan,
I was never able to define large datasets in Oracle letting Geoserver find
the bounding box and thought it is a Geoserver problem but it is not.
As you said and Andrea confirmed in the background on the oracle level it
must be one of these commands:
SELECT SDO_TUNE.EXTENT_OF('TABLE_NAME', 'SPATIAL_COLUMN') FROM DUAL;
or
SELECT SDO_AGGR_MBR(SPATIAL_COLUMN) FROM TABLE_NAME;
Running the SDO_TUNE.EXTENT_OF on a dataset with 3.3 million features I gave
up after 15 mins.
Trying the command with smaller datasets I get the following numbers.
secs feature numbers
1.6 935
1.9 3700
7.6 28000
30.25 105000
Sort of linear increase and atrocious performance. The 'SDO_AGGR_MBR' is
even worse. So, I get the BBox from ArcSDE and hack it in by hand which
infuriates me, because I think a decent spatial database should work on its
own resources.
Geoserver is 2.1.3 and all the tables have spatial indices.
Anything I might do wrong with the DB or any solutions for that?
Cheers
Christian
-----
____________________________
Dr Christian Maul
Project Manager
Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000
PO Box 500, East Melbourne Vic 3002
Telephone: +61-3-8636 2325
Telefax: +61-3-8636 2813
--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/SDO-TUNE-EXTENT-OF-Oracle-tp5025640p5026061.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
