In most kdb systems its typical to reload the hdb (l .) after any data persistence has occurred. With larger hdbs, this reload can sometimes be costly especially when there are multiple flat files.
With a standard TAQ database, what are some best practices for when to actually reload the hdb?
Some thoughts
- New date partition – no need to reload
- Splayed table changes – no need to reload. Tables are mapped when the executing process tries to access it
- New enumeration – no need to reload
- Updates to flat files – reload