Hi, > I tried to switch from hsql to h2 for running test with in-memory > databases, but the tests take almost precisely twice as long to run > with h2. Is that because we use a lot of blobs? It seems to me that h2 > uses files for storing blobs, even in in-memory mode. Can this be the > case? I thought in-memory mode means now slowing-down i/o whatsoever > (except for the possibility to connect squirrel via tcp for debugging > and demonstration, which is really the reason why i want to switch . > incredibly neat feature!).
What version of H2 and HSQLDB do you use? Could you post the database URLs, schema (tables, indexes), and (if possible) the test application? H2 is not optimized for the in-memory mode, so it's possible that HSQLDB is faster - however there could be many reasons why that is the case. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
