Minimizing data storage

LN can require quite some data storage depending on the application configuration.

  • Oracle
    It is possible to compress data within Oracle for LN. For more specific information, check solution number 225096. This solution provides performance related topics which deserve special attention or are not yet published via the regular documentation. Also a solution number about compressing data within Oracle is provided here. Download the solution at http://www.infor.com/inforxtreme.
  • MS SQL Server
    For SQL Server, the porting sets 8.4b and later will, by default, use the SQL Server varchar type for storing string information. This can cause quite a decrease on data storage usages. For companies that have an existing Baan 5.0 or LN 6.1 installation that want to move to 8.4b or later, it is highly recommended to check the technical notes of the porting set. The technical notes provide information about how to change existing tables to use varchar instead of char type.