The database takes up too much memory. How do I reduce the memory requirements?
The default configuration has all performance optimizations turned on. Performance optimizations sacrifice memory for better performance, so to reduce memory requirements you will need to alter the performance properties in the database configuration file. The most obvious property to change is the data cache size. A small database has little to gain from a large cache anyway so try reducing this first. See the documentation on the configuration properties for further options for optimizing the database. Don’t forget to shutdown and restart the database after the configuration file is changed. 9.3.
Related Questions
- Database statistics can also be used as part of database monitoring (for example, to determine memory requirements).2. When are database statistics not required?
- When attempting to rollforward from a checkpoint, Im getting memory errors - how can I reduce the memory requirements?
- The database takes up too much memory. How do I reduce the memory requirements?
