If it's just the first connection, then it's probably a startup issue i.e. the first time you touch H2, we have to start
the server and initialise all the internal data, which MySQL does not need to do because it's already running.
If it's every connection, then you may need to some performance tuning:
http://h2database.com/html/performance.html
The encryption will definitely slow things down - how much I'm not sure, but it would be useful to get a more accurate
comparison.
On 2014-03-24 09:45, ryan Povey wrote:
Hi
I use the Glassfish connection pool to query. All queries run slowly, but not
sure if its the first connection or not.
No I am not encrypting MySQL, but I am encrypting H2 for security reasons. Just
had to changed to MySQL to get speed up,
but I am now less secure.
I will attempt the test with a H2 database and no encryption, but I still need
to encrypt the database I use for security.
Does the encrypting slow down H2 quite a bit?
I'm back at work so can answer questions timeously now.
--
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 http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
