Hi,

I have a strange behavior with MonetDB and the JDBC driver, maybe you have an explanation.

Here is what I do :
I import about 100 000 rows in MonetDB using the JDBC driver and simple SQL statements (not prepared) with Spring JDBC API.

I made the test a first time using sequences, so before inserting the data I query for the next sequence number and then I insert the data.
The second time, I generate the sequence number on the application side, using a simple increment, so I directly insert the data.

And the strange result :
In the first test, it took 7:30 minutes for the whole insert.
In the second test, it took only 30 seconds for the whole insert.

So, it seems there is a problem with the select performance, and in fact I saw this problem for another select operation.

Do you have any idea about where it can come from ? Is there any configuration option or the way I use the JDBC API ?

Thanks,

Cimballi