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.
