It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Hypersonic vs MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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.
I agree. Here's the link:
subject: Hypersonic vs MySQL
It's not a secret anymore!