This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hypersonic vs MySQL

 
meka toka
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic