I have 7 tables and some tables are empty and some has only one row. In
table maximum 5 columns, no any extra indexes and I make quite simple sql
queries.
This is how I run h2.
java -jar h2-1.3.176.jar
Quaries are generated and executed by eclipselink 2.6.3. These are my
settings in persistence.xml
<properties>
<property name="eclipselink.connection-pool.default.initial"
value="5"/>
<property name="eclipselink.connection-pool.default.min" value="5"/>
<property name="javax.persistence.jdbc.driver"
value="org.h2.Driver"/>
<property name="javax.persistence.jdbc.url"
value="jdbc:h2:tcp://localhost//home/somepath;DATABASE_TO_UPPER=FALSE"/>
<property name="javax.persistence.jdbc.user" value="sa"/>
<property name="javax.persistence.jdbc.password" value=""/>
<property name="eclipselink.logging.level" value="FINE"/>
<property name="eclipselink.logging.thread" value="false"/>
<property name="eclipselink.logging.exceptions" value="true"/>
<property name="eclipselink.orm.throw.exceptions" value="true"/>
<property name="eclipselink.left-join-fetch" value="true"/>
<property name="eclipselink.weaving" value="true"/>
</properties>
So every sql query is executed about one second(!). Besides I hear that for
every sql query hard drive is working hard.
However, when I in H2 webconsole press connect to the same DB, then my java
program works very fast. It works fast until I press disconnect in
webconsole. How to explain this?
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
