MySQL Forums
Forum List  »  GIS

Re: Spatial relationships between geometries
Posted by: Peter Yuill
Date: August 30, 2006 10:22PM

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.

Options: ReplyQuote

Written By
Re: Spatial relationships between geometries
August 30, 2006 10:22PM

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.