Precompilers and OCI (MOSC)

MOSC Banner

OCCI poor performance fetching sdo_geometry

edited Feb 28, 2011 2:02AM in Precompilers and OCI (MOSC) 6 commentsAnswered
 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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center