java - Why is H2 slow when updating Blobs? -

java - Why is H2 slow when updating Blobs? -

i need sort of persistance componnent store id(long) , value(object) java application.

all cacheing systems looked @ not persistant enough(if process died cache erase itself) or slow

i tried utilize embedded databases derby , hsqldb not fast h2 select , insert.

for reason update query takes 1-2 seconds 1 row if update row blob.

does know why slow?

queries:

create table entities(id bigint primary key, info blob) insert entities(data, id) values(?, ?) update entities set info = ? id = ?

i using jdbc preparedstatement

edit:

the connection string is:

jdbc:h2:c:\temp\h2db;file_lock=no;

i tried add together cache_size=102400 , page_size=209715200 didn't help

java jdbc blob h2