Il 08/01/2013 07:18, cmaul ha scritto:
> 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
Hi,
I made a short comparative study about usage of Oracle Spatial for a
rather large dataset we are planning to use, about 100k features with .
I tested the both bounding box, aggregate and intersection function over
the whole dataset. It turned out performances on the db side were
unacceptable, even on a fairly good workstation (2 quad core xeon procs,
32G ram and SAS hds).
I had to skip Oracle in favour of PostGIS, the performances on my quad
core development pc are order of magnitudes better.
I can confirm it's not a Geoserver issue, the same Geoserver that was
sluggish on Oracle Spatial became blazing fast when hooked to Postgres.
I don't know if Oracle Spatial performances get better on big mainframes
or racs, if you can afford them.
Regards,
Paolo
--
Paolo Crosato
------------------------------------------------------------------------------
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
