Earlier this year I moved to El Capitan. Ever since I've been finding the 
h2 console very very slow. Here are timings taken a few days ago with no 
other apps running:

   - 2 min 5 sec: Launch the console and wait for it to finish loading. 
   Uses a shell script which does the following:

cd "/Applications/h2 1.3.167/bin"
java -cp h2-1.3.167.jar org.h2.tools.Server

   - 2 min 48 sec: Click on the console's Connect button in my browser and 
   wait for the database to be opened and the console to be ready to work
   - 2 min 20 sec: Run a very simple query which the DB engine takes 18ms 
   to process
   - 21 sec: Click on the console's disconnect button and wait to be back 
   at the console's "front page"
   
I don't believe this has anything to do with my browser or its 
addins/extensions, since the slowness starts right back in the Terminal.  
It used to be that the messages about starting up the TCP and PG and Web 
servers flashed up on my Terminal window really fast, and then my browser 
came out.  Now it takes something like a half minute until the first 
message shows, then the other two probably take about 20-30 seconds each 
also.

As can be seen above, I'm running h2 version 1.3.167; the other day I tried 
using 1.3.176 but it was equally slow and gave me an error once the 
database was finally opened.  I will eventually upgrade to 1.3.176 but 
right now my priority is getting the console back into usable state.

Running java -version in my Terminal gives the following result:
java version "1.8.0_101"
Java(TM) SE Runtime Environment (build 1.8.0_101-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.101-b13, mixed mode)

The machine is currently on 10.11.6.  No antivirus software, and all other 
apps work just as usual while this slowness is happening.  Even other 
webpages load as quickly as usual.  It's just the console code which is 
being affected.

My Java app, which uses the same database as used in the timing run above, 
is also running just as fast as usual.

Please can some kind soul help me fix this?  I like h2 but this is driving 
me nuts.

-- 
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.

Reply via email to