OCCI poor performance fetching sdo_geometry
Hi all,
I have a sample program that:
- makes a query with only one field of type mdsys.sdo_geometry (1926 records)
- Iterates the resultset (rs->next()) and reads the geometry: geom = (SDO_GEOMETRY *) rs->getObject(1);
This program ends in 5172 ms
The same sample program in Java, using ojdbc14.jar and sdotools.jar APIs, ends in 2547 ms
I think I'm doing something wrong in occi usage but I cannot figure out what... ((or there must be another way to fetch geometries faster)
Thanks in advance for any hint
Code fragment follows (SDO_GEOMETRY is the OTT generated class):
env = Environment::createEnvironment(Environment::OBJECT);
- makes a query with only one field of type mdsys.sdo_geometry (1926 records)
- Iterates the resultset (rs->next()) and reads the geometry: geom = (SDO_GEOMETRY *) rs->getObject(1);
This program ends in 5172 ms
The same sample program in Java, using ojdbc14.jar and sdotools.jar APIs, ends in 2547 ms
I think I'm doing something wrong in occi usage but I cannot figure out what... ((or there must be another way to fetch geometries faster)
Thanks in advance for any hint
Code fragment follows (SDO_GEOMETRY is the OTT generated class):
env = Environment::createEnvironment(Environment::OBJECT);
0