New subject: [MonetDB-users] Strange performance behavior on bulk import with / without sequences

11 Mar 2009

      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

[MonetDB-users] Strange performance behavior on bulk import with / without sequences

Cimballi

Martin Kersten

Cimballi

Martin Kersten

tags

participants (2)