Hello, I'm in the middle of evaluating H2 (running the latest release) and did a test with 4 million entries. My table schema looks like this:
create table PUBLIC.MARKUP ( ID integer generated by default as identity primary key PROCESS_ID integer not null X integer not null Y integer not null Z integer not null) PROCESS_ID goes from 0 to 40000, X and Y are randomly generated between 0 and 20000, and Z is from 0 to 1000. I made two indexes, one on PROCESS_ID and the other a multi-column index on ZXY. I generated this test data as a CSV file which is around 1.1GB and the resulting H2 DB with indexes comes to nearly 9GB. I'm still testing for query speed, but it's been difficult because I've gotten really bad startup time (around 10 mins) - I ran test connection in H2 Console and the stack trace is here: http://gist.github.com/477673. In my connection string, I use these parameters: LOG=2;CACHE_SIZE=2048000. The FAQ says that H2 Console will show progress information, but I can't figure that out. Is it slow because it's rebuilding indexes on every startup? Thank you. Duncan. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
