ODBC 2.0 drop in performance

[Laura M. Castro Souto]

Ingela Anderton wrote:

> 
> How much is a "rather high" performance drop? You could always try to
> run it in a very clean environment to try to eliminate other factors
> such as high network load etc..
> 

   In fact, we have tested exactly the same configuration of our 
application with both Erlang-R9C-0 and Erlang-R9C-1. To be able to have 
a measure of this performance drop we have massively populated our 
database in these environments and the difference is about 5 times. 
Besides, this behaviour shows not only on write but on read queries as 
well. The network load is not critical, because we obtain the same 
results if we have server, database and client running on the same machine.

   Of course we could go back to Erlang-R9C-0, but we are aware of the 
memory management problems on ODBC 1.8, since we have dealed with the C 
code and fixed some minnor bugs. These seem to have been removed with 
the new implementation, so it would be better for us to use the new and 
corrected ODBC release.

   By the way, we guessed we have found some little mistakes in the C 
source code driver Makefile (dissabled optimizations, debugging options 
enabled, etc), but they are not the reason for the performance drop.

   Any help would be very welcome :-). Thank you!

	Laura M. Castro