Hi, I'm using H2 as a local database system for development. I looking for the best performance and resource efficiency settings, memory is not a problem and I would gladly change anything to get the fastest response time it can offer. Currently I have 2 databases, one for Pentaho Kettle repository and the other one for the ETL control and reference tables that serve as local copies of production databases. I use DBvis 7.2 and Pentaho Kettle 3.2.4, both java apps, and I only "invoke" the database from the jar as jdbc, with Pentaho I had to copy the jar to it's special sub-directory, and DBvis could read it from my h2 folder.
I just define jdbc connection like: jdbc:h2:~/apps/h2/repo And: jdbc:h2:~/apps/h2/local I use them both at the same time 90% of the time. So I would like to think it's running on embedded mode, but I don't fully understand how it works and what would be the best config. I mean, is this OK? Having the same jar file at 2 different locations, each used by a different app? Having 2 different databases? (I could easily merge the databases into one) Having them loaded on-demand by the app? (I could launch it at startup with java -jar ~/apps/h2/h2-1-3-154.jar, right?) -- 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.
