hi,

I use H2 as in-memory database for jBPM. in my case, there are lots of 
inserts/updates/deletes, but each table only has very limited records,(max 
10 records), there are total about 15 tables.

During my performance testing, I always ran into out-of-memory exception 
after couple hours. I found the record numbers are correct, and when I use 
'script to' command to export the database, the whole file is less than 1M. 
But in the memory dump, I found the following:


Class Name                         |   Objects | Shallow Heap | Retained 
Heap
------------------------------------------------------------------------------
.*org.h2.result.*                  |           |              |             
 
org.h2.result.Row                  |   186,953 |    7,478,120 |   
539,815,536
org.h2.result.LocalResult          |        33 |        2,376 |      >= 
7,624
org.h2.result.SortOrder            |         6 |          144 |        >= 
424
org.h2.result.Row[]                |         1 |           16 |         >= 
16
org.h2.result.ResultExternal       |         0 |            0 |             
 
org.h2.result.ResultInterface      |         0 |            0 |             
 
org.h2.result.SearchRow            |         0 |            0 |          >= 
8
org.h2.result.RowList              |         0 |            0 |             
 
org.h2.result.SimpleRow            |         0 |            0 |             
 
org.h2.result.UpdatableRow         |         0 |            0 |             
 
org.h2.result.ResultTarget         |         0 |            0 |             
 
Total: 11 entries (27,510 filtered)|   186,993 |    7,480,656 |     


I use the following url <prop key="URL">jdbc:h2:mem:taskDB</prop>
and I tried to change the URL with one or more than one of following 
parameters
;MVCC=TRUE;DB_CLOSE_DELAY=-1;LOG=0

But the result is same. I always run into out-of-memory.

I tried the latest version 1.3.170 and previous version as well.

I do have blob objects in my database, and insert/delete the blob many 
times.

Any suggestion?

Thanks

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/sCQTIq0F784J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to