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
4921
January 18, 2006 04:31AM
2961
January 18, 2006 11:20AM
3303
February 02, 2006 04:36PM
3032
August 24, 2006 10:54PM
Re: Spatial relationships between geometries
2926
August 30, 2006 10:22PM
2829
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.