O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Performance of Java-based SQL processing

If a function is not available natively in Oracle, then having it become available via a custom Java function is a reasonable compromise! Even so, to be really useful, such code must operate correctly and efficiently.

Much has been written on the performance of PL/SQL against native SQL functionality, with some also available for Java-based stored procedures. From such work you can discover a set of guidelines for creating fast executing functions.

While little can be done about the cost to call a Java Stored Procedure from SQL (c.f., context swapping), one does have control over the efficiency of the implemented algorithm. JTS is particularly known for this, such that its algorithms are well understood. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required