Performance probs with Connect 4.2 for Oracle Wire

Hi,

We've just started evaluating the Data Direct ODBC Oracle driver and comparing performance with Oracle's own driver in a development project we're undertaking.

We have struck a problem - functionally the driver's working OK, but we have a performance problem that is associated with the ODBC connectivity layer.

In our application, we use stored procedures a lot, and return result sets from them.

It seems that in the Wire driver, every time a statement is executed that calls a stored procedure, the column metadata is returned even when it's not explicitly asked for with the SQLDescribeCol calls. If we select the driver option to "Describe at prepare time" and do the statement as a prepared statement, this doesn't make any difference. (However, for a 'normal' query, i.e. not a stored proc, this works as expected).
We understand that the metadata could well be different from one call to the next of a stored procedure, which is why it can't really be worked out at prepare time, however this is clogging up the LAN. It should only come back to the app from the server if it is explicitly asked for?

The amount of metadata is frequently a number of times larger than the data itself.

Because we are also executing queries quite frequently, (with small result sets), this is causing overall performance degradation.

Any ideas or recommendations?

Thanks...

--
Posted via http://dbforums.com