Hi Davide,
Interesting, I figured SDO_TUNE was using the spatial index, but not
metadata bounds held by it. My own tests per the earlier spreadsheet (
https://docs.google.com/open?id=0B22cYd3gwE-6MkRfdlp6VFNOZjQ) still have it
be quite slow for 19.9million features - it took about a minute.
Useful to know though, Cheers,
Jonathan
On 10 January 2013 10:58, Davide <[email protected]> wrote:
> On Thu, Jan 10, 2013 at 10:31 AM, Jonathan Moules
> <[email protected]> wrote:
> > 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.
>
> Hi Jonathan,
>
> SDO_TUNE.EXTENT_OF should use the spatial index of your table.
> The spatial index root contains the bounding box of all geometries in
> the column, that's why it fast, no need to calculate anything.
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
> more information.
> ==
>
> Davide Savazzi
> @svzdvd
> Senior Software Engineer
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
>
> ------------------------------------------------------------------------------
> 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
