Search code examples
javadatabasehsqldb

Can HSQLDB handle a few millions of rows?

I'm developing a singler user application that needs a database. Most tables will have a reasonable amount of data, but there are a few that may grow to a few millions of rows. None of my queries will return a large result set.

Anyone know if HSQLDB can handle such a large number of rows?

Solution

  • HSQLDB can handle millions of rows. You can try some of the test classes which can create large databases. For example:

    http://hsqldb.org/web/hsqlPerformanceTests.html

    Or here: https://sourceforge.net/p/hsqldb/svn/HEAD/tree/base/trunk/src/org/hsqldb/test/

    Check the TestCacheSize and TestStressInsert classess.

    You should use the built-in backup capability and regularly backup the database.