Here is what's happening :
I'm using a table like this :
CREATE TABLE IF NOT EXISTS TMPACKETS(id int primary key auto_increment,
type varchar(64), reception_time TIMESTAMP, onboard_time TIMESTAMP, data
varbinary(50))
I'm inserting with prepared statement like this :
this.preparedStatement = this.conn.prepareStatement("INSERT INTO TMPACKETS
(TYPE, RECEPTION_TIME, ONBOARD_TIME, DATA) VALUES (?,?,?,?)");
My DB size is now 2GO. I'm doing a lots a of inserts in a row. I've noticed
that when I do precisely 18689 inserts in a row then the 18688 firsts are
as fast as usual, but the number18689, the last one, is really slow (around
3 sec for 1 insert). I can repeat the same operation every time and for
this precise insert number 18689 it takes 3 seconds and blocks the h2
database (impossible to perform a read at the same moment).
I've noticed that is was not coming from the speed I'm doing the inserts,
it blocks every time at the insert number 18689, no matter at what speed I
do it.
What it even more strange it is that if I just do 18688 inserts in a row
and close my app (close the java vm) and re-run 18688 inserts in a row it
goes well every time and I can do it as much as I want. But if I do one
more insert then I have to wait 3 seconds more on the last insert, which is
quite a long time.
Did anyone already faced this issue? Is 2GByte to much to handle for H2?
Thanks for your help,
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
