SHUTDOWN COMPACT

Alexandre
2005-02-25
2014-01-19
  • Alexandre
    Alexandre
    2005-02-25

    Hello !

    I'd like to know if I can ever use SHUTDOWN COMPACT instead of  just SHUTDOWN in my application. That's  why with SHTUDOWN, HSQLDB increases de .data file's size much faster and I'll need to make many inserts, updates and deletes. I'd like to know if it can bring me some problem with it's frequently use.

    Thanks !

     
    • Fred Toussi
      Fred Toussi
      2005-02-25

      It's fine to use SHUTDOWN COMPACT each time. Usually it takes longer than SHUTDOWN but in some cases it can take less time.