Re: Spatial relationships between geometries
An application level filter in Java is always going to be slower than a native in-database solution.
A significant part of the time to perform the filter is creating the JTS Geometry objects. Using Well Known Binary (WKB) instead of Well Known Text (WKT) is definitely faster, but there is a serious catch with MySQL. There is a killer bug in the server that the development team refuse to fix. It declares the return from the AsBinary() function as String, so modern versions of Connector/J perform string translation on it and corrupt the result. The 3.0 releases of Connector/J work fine because they do not apply string translation.
Subject
Views
Written By
Posted
4844
January 18, 2006 04:31AM
2922
January 18, 2006 11:20AM
3230
February 02, 2006 04:36PM
2986
August 24, 2006 10:54PM
Re: Spatial relationships between geometries
2873
August 30, 2006 10:22PM
2769
September 04, 2006 09:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.