
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