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
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