We're updating the issue view to help you get more done. 

Store geometries in Oracle as points (when they are points) instead of array of points

Description

Hi there, first of all, apologies in case I don't follow your procedures, as I'm new in this project.
Our use case is that we use Hibernate-spatial to store and query millions of points in Oracle that will be shown on a map.
I saw in OracleJDBCTypeFactory that the createStruct will store points as array of points ( SDO_ORDINATE_ARRAY ) instead of actual points ( SDO_POINT_TYPE ) which is not that performant.
My current pull request suggests that we could use SDO_POINT_TYPE.
I understand that maybe this is something that was already discussed in this project so I'm open to any kind of comments.
In case this is ok with you, I created a pull request with my approach to the change :
https://github.com/GeoLatte/geolatte-geom/pull/42

This is something I have seen in Hibernate for a good while, but it is only now that I thought about submitting a pull request. I mean this is not relevant to a particular version.

Thanks for your time.

Environment

None

Status

Assignee

Unassigned

Reporter

Ignacio Calvo

Components

Affects versions

5.1.0

Priority

Major