Results 1 to 3 of 3

Thread: HSQL or MySQL

  1. #1
    sole is offline Member
    Join Date
    Jan 2010
    Posts
    6
    Rep Power
    0

    Default HSQL or MySQL

    Need an advice from all the experts out there!

    I am working on a client server based application - that needs to accumulate data over time ~ 100 MB per month. Do not foresee any cleanup of the data - it will just accumulate, and only the latest data will be used more frequently, older data would be required only occasionally. I am not able to decide which database should be good for such an application? Traditional MySQL? Or the Java based ones like HSQL / H2 / Derby?

    I checked out many discussions on the related topics that discarded H2 and Derby as not up to the mark - leaving me with MySQL and HSQL. For these, I found a lot of contradictory points - some say that MySQL is sturdy and has a lot more capacity while others promise HSQL is a lot more fast and sleek - easy to package and deploy, etc. Some crib about HSQL hogging RAM.

    Basically I am confused if my requirement of 100 MB per month classifies as huge data or small? How bad is the HSQL Ram usage? Is there a way to neatly package MySQL with an application? Or make HSQL digest more data? Is there any other criteria to decide? Or any other alternative?

    Do let me know your views

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,015
    Rep Power
    20

    Default Re: HSQL or MySQL

    What are you going to do with this accumulated data?

    To be honest I'd go (in a server environment) for MySQL.
    I tend to view the others as decent databases for embedding in an app, not for a client/server situation.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  3. #3
    sole is offline Member
    Join Date
    Jan 2010
    Posts
    6
    Rep Power
    0

    Default Re: HSQL or MySQL

    The data would be used mainly for generating monthly reports - at the end of the month. And occasionally for review of the trends, etc. Rest of the time, they will only accumulate data. That is why I was a bit lazy about using a full fledged database like My SQL.. But as you said, on the Server side, it may be worth the one time effort to have it installed for once!

    Thanks!

Similar Threads

  1. Replies: 4
    Last Post: 03-04-2012, 11:26 PM
  2. MySQL
    By PhQ in forum New To Java
    Replies: 6
    Last Post: 04-03-2010, 12:54 PM
  3. SWT and mysql
    By ashin in forum SWT / JFace
    Replies: 4
    Last Post: 07-09-2009, 04:46 AM
  4. MySQL/JDBC Mysql query output
    By thelinuxguy in forum Advanced Java
    Replies: 4
    Last Post: 02-13-2009, 01:57 AM
  5. Creating Hibernate HSQL connection
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 12-13-2007, 09:11 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •