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
5189
January 18, 2006 04:31AM
3083
January 18, 2006 11:20AM
3426
February 02, 2006 04:36PM
3165
August 24, 2006 10:54PM
Re: Spatial relationships between geometries
3040
August 30, 2006 10:22PM
2951
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.