wood burning stoves*
The moose likes JDBC and the fly likes Hypersonic vs MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Hypersonic vs MySQL" Watch "Hypersonic vs MySQL" New topic

Hypersonic vs MySQL

meka toka
Ranch Hand

Joined: Dec 11, 2002
Posts: 75
We use JBoss 3.0.6 and now we are at a stage to decide about the database to use. Our project is a mid-size one and we being limited on funds we would be leaning more towards the open source tools.
We narrowed down to MySQL.
I tested my application with MySQL and Hypersonic(the one that ships with JBoss)
I noticed a huge difference in speed, Hypersonic seemed to be very fast compared to MySQL.
Is Hypersonic to be trusted ?
Any Comments
Meka Toka

Thanks<br />MekaToka<br />SCJP 1.4
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

If I'm not mistaken, the story goes like this: (I've used MySQL, but not Hypersonic)
MySQL is a free 'real' database in the sense that it is used in many production systems, even though it is missing a few common database systems.
Hypersonic is a memory-resident test database. The fact that all data is kept in memory accounts for the speed difference. I doubt this database would behave well in real situations and personally I wouldn't trust it. Feel free to use it in testing since it is handy, don't use it in production.
Don't get me started about those stupid light bulbs.
subject: Hypersonic vs MySQL
Similar Threads
Hibernate: How to avoid drop & recreate of table on Server restart
won't create tables with jaws.xml
Error while starting jboss(java.lang.ClassNotFoundException: No ClassLoaders found for: com.mysql.j)
database directions for beginner
Failed to Deliver: java.lang.IllegalStateException: Unexpected pageOrd: