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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Hypersonic vs MySQL" Watch "Hypersonic vs MySQL" New topic
Author

Hypersonic vs MySQL

meka toka
Ranch Hand

Joined: Dec 11, 2002
Posts: 75
Hi,
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
Regards
Meka Toka


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

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.
Dave
 
It is sorta covered in the JavaRanch Style Guide.
 
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: