Hi Christian,
Wow, that's fast for 19million features, but at that speed I'd assume it
has the bounds pre-calculated; its probably getting them from
MDSYS.USER_SDO_GEOM_METADATA or similar, but I don't know how Oracle 11
does things.
It seems like Oracle 11 is better at data integrity and maintaining its
spatial metadata than 10.
Jonathan
On 10 January 2013 01:31, cmaul <[email protected]> wrote:
> Hello,
>
> I think I found the problem Oracle 10.2.0.3.0 /Oracle 11.2.0.3.3
>
> SELECT SDO_TUNE.EXTENT_OF('VMPROP.POINT', 'SHAPE') FROM DUAL;
>
> DB features time
> Oracle10 19Mio >30mins and no result
> Oracle11 19Mio 0.375 seconds
>
> and guess what? Suddenly Geoserver has no problems finding a bounding box.
>
> 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-tp5025640p5026521.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122712
> ________________________
_______________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
This transmission is intended for the named addressee(s) only and may contain
sensitive or protectively marked material up to RESTRICTED and should be
handled accordingly. Unless you are the named addressee (or authorised to
receive it for the addressee) you may not copy or use it, or disclose it to
anyone else. If you have received this transmission in error please notify the
sender immediately. All email traffic sent to or from us, including without
limitation all GCSX traffic, may be subject to recording and/or monitoring in
accordance with relevant legislation.
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
