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.
It's fine to use SHUTDOWN COMPACT each time. Usually it takes longer than SHUTDOWN but in some cases it can take less time.