I recently began to use H2 database as storage of my data for experiments. My data is now in H2 embedded database, and now I need to import the data in the embedded database into an in-memory database. I have tried to first backup the embedded database as SQL file and then create the in-memory database by executing the SQL file using RUNSCRIPT. However, the query on the in-memory database is very slow, even slower than the embedded database! I used hash index for both databases. Could someone help me to figure out what is wrong? Thank you very much in advance.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.