DROP TABLE

2013-07-15
2014-01-19
  • Tapan Sharma
    Tapan Sharma
    2013-07-15

    Hi All,

    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.

    Regards
    Tapan

     
  • 1234
    1234
    2013-07-15

    checkpoint defrag

    Also a good idea to run occasionally to get dead space out of OS level files.  Do when access is not required.

     
  • Tapan Sharma
    Tapan Sharma
    2013-07-16

    Thanks jcpalmer. It worked for me.