I have a question to better understand how works a spatial query in oracle.
I have to return some geometries with a query, create a GeometryProvider Layer, then load the List<Geometry> result of my query in that layer.
My db is pretty big, but I created all the indexes needed by the query, the spatial index and ran that SDO_MIGRATE.TO_CURRENT function.
My average query has to return something like 500 geometries, and following the examples, I structured the query like this:
select g.geometry_column.Get_WKB() from table g where Column1=Value1
and in the code I act like this:
The time for the operations is (for 500 geometries)
Read from database (without the GeometryFromWKB function): 4 sec
Read from database AND do the GeometryFromWKB: 9 sec
Now, what I don't understand is: why I have to convert the geometries first in WKB and then re-convert the data into geometries? Am I wrong?