We are using HSQL 2.2.9. We are creating the cached table in HSQL having millions of rows.
Whenever we are dropping the table, though the table doesn't exist, the data file size doesn't get reduced.
Any idea, is there some background process that would remove the contents of data file. Or is there any command/configuration needed to do the same.
Also a good idea to run occasionally to get dead space out of OS level files. Do when access is not required.
Thanks jcpalmer. It worked for me.