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
5320
January 18, 2006 04:31AM
3170
January 18, 2006 11:20AM
3501
February 02, 2006 04:36PM
3230
August 24, 2006 10:54PM
Re: Spatial relationships between geometries
3109
August 30, 2006 10:22PM
3017
September 04, 2006 09:52PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.