llection
> (instead of previous suggestion)
> 3) try PRIMARY KEY HASH (it also uses HashMap for lookups);
> 4) try to add heap memory as much as possible (to decrease GC
> pressure)
>
> If this still too slow look at TableEngine api to implement your own
> table.
>
> regard
I am using H2 as an embedded database in a Java 1.6 application. The
Database is in-memory. I create a single table using 'CREATE MEMORY
TABLE TestTable'. I have an index on what we call our ID field and put
this at the end of the table creation sql: 'PRIMARY KEY (id)'
The purpose of the applicati