GeoTools

Use SDO_TUNE.EXTENT_OF to compute bbox for Oracle data types

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 2.3.2, 2.4-M4
  • Fix Version/s: 2.3.3, 2.4-RC0
  • Component/s: jdbc-oracle plugin
  • Labels:
    None

Description

At the moment a (horror) feature by feature computation is done instead, oh poor us...

Issue Links

depends upon

Improvement - An improvement or enhancement to an existing feature or task. GEOT-1507 Check for availability of EXTENT_OF and fall back transparently on SDO_AGGR_MBR

  • Major - Major loss of function.
  • Resolved - A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.
is depended upon by

Bug - A problem which impairs or prevents the functions of the product. GEOS-1258 Fast bbox computation missing for Oracle

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Andrea Aime added a comment -
Fixed on 2.3.x, 2.4.x and trunk
Show
Andrea Aime added a comment - Fixed on 2.3.x, 2.4.x and trunk
Hide
Permalink
claudio silvestri added a comment -
The function EXTENT_OF is deprecated, SDO_AGGR_MBR should be used instead
Warning: SDO_AGGR_MBR result can be a point or a line in some particular case, see usage notes for details

Regards
Claudio Silvestri

http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10826/sdo_objtune.htm#i857307
****************
This function is deprecated, and will not be supported in future versions of Spatial. You are instead encouraged to use the SDO_AGGR_MBR function, documented in Chapter 14, to return the MBR of geometries.
****************

Show
claudio silvestri added a comment - The function EXTENT_OF is deprecated, SDO_AGGR_MBR should be used instead Warning: SDO_AGGR_MBR result can be a point or a line in some particular case, see usage notes for details Regards Claudio Silvestri http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10826/sdo_objtune.htm#i857307 **************** This function is deprecated, and will not be supported in future versions of Spatial. You are instead encouraged to use the SDO_AGGR_MBR function, documented in Chapter 14, to return the MBR of geometries. ****************
Hide
Permalink
Andrea Aime added a comment -
This is bad, because SDO_AGGR_MBR is way slower. We'll need to add a check and see if EXTENT_OF is available, if not, we'll have to use SDO_AGGR_MBR, and let's hope Oracle does something to speed it up...
Show
Andrea Aime added a comment - This is bad, because SDO_AGGR_MBR is way slower. We'll need to add a check and see if EXTENT_OF is available, if not, we'll have to use SDO_AGGR_MBR, and let's hope Oracle does something to speed it up...
Hide
Permalink
Andrea Aime added a comment -
Created a new issue to avoid forgetting this... to really fix it, we need either funding again, or someone willing to do the Oracle mantainer (at the moment I'm kind of filling that position just to avoid the Oracle data store major breakages)
Show
Andrea Aime added a comment - Created a new issue to avoid forgetting this... to really fix it, we need either funding again, or someone willing to do the Oracle mantainer (at the moment I'm kind of filling that position just to avoid the Oracle data store major breakages)

People

  • Assignee:
    Andrea Aime
    Reporter:
    Andrea Aime
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: