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.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks