In short in HSQLDB cached table sucks in terms of performance. To elaborate I was running a program which takes around 9 hours running on two medium sized cached tables (bigger one 163 MB). I changed the tables to memory tables (default) and it now takes less than 10 minutes. Let's see how we can easily convert memory table to cached table and vice-versa.

Read more (336 words) »

HSQLDB is a high performance RDBMS written in pure Java. It can be used as a in-memory database or regular file based database. It can also create a read-only database out of any CSV files. HSQLDB is the database used with OpenOffice. The steps to quickly and safely backup HSQLDB Database are:
Read more (187 words) »

I previously discussed how to extend HSQLDB relational database with simple Java functions. The example there actually implements case insensitive like query functionality for HSQLDB. Read the article to get an understanding of how to write such custom functions and how to use them. Then read below to find a solution for performing space crunched comparison of strings.

Read more (237 words) »

HSQLDB is an unique high performing, high quality Java based relational database which can be very easily extended with simple Java static functions. Here we will see how you can easily extend the database capability with a real-life example.

Read more (243 words) »

All I really want is to store a very large Hashtable with more reads than writes. It should be able to deal with more than 8GB of data. The key will be a String of limited length. I want it to be extremely fast on read-access, stable with sudden shutdown and other issues beyond our control and with very low CPU usage. The leading contenders in my mind are:
Read more (158 words) »

While inserting a SQL query we do not specify the auto increment values, if any. However they are often required for further processing. Here is how you can obtain auto increment / auto generated values after a successful SQL INSERT statement.
Read more (127 words) »

Sometimes you need to have database column names with space or other non-standard characters. The standard procedure is to escape them with backtick (`) character. HSQLDB doesn't accept either backtick or single quote as escape character. Instead you have to use escaped double quotes as shown in the example below:
Read more (103 words) »