Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
Workspace Jedox Platform
Categories In-Memory DB
Created by Guest
Created on Jul 26, 2024

Improve server performance with Configuration Option to Disable Loading Inactive Databases on server startup

We have clients who archive previous databases from prior years (but these are still saved on the Jedox server so they can access the database if needed).


By default, Jedox loads all databases into memory at server startup. This means the inactive databases are unnecessarily using RAM and impacting performance.


To improve server performance, we then log into the OLAP Browser and manually Unload these inactive databases. But then on server restart after each nightly maintenance, these databases are loaded again.


Oracle Hyperion had a flag that one could check per database that preventing the automatic load on server startup. This would be helpful for Jedox.

  • ADMIN RESPONSE
    Aug 2, 2024

    Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog.

  • Guest
    Reply
    |
    Sep 16, 2024

    This will save Jedox money!!! Disable feature for inactive databases should get a priority! There are hundreds if not thousands of models out there that are not active and chewing up RAM which costs Jedox money for the RAM. We have customers that save multiple copies of older versions of their models for development and for old Chart of Account reports that are not actively used on even a yearly basis. Plus it will make Jedox more stable when a memory spike hits.

5 MERGED

Selectively load databases

Merged
It would be good if databases could be prevented from loading on start through a settings file, and then manually loaded later on, or it would at least be good to be able to change the database load order This would mean that we could ensure criti...
over 4 years ago in Jedox Platform / In-Memory DB 1 Future consideration
7 MERGED

Load on Demand Models option

Merged
Have an option to set a Jedox Model to only load on demand. If not set to load on startup, it only loads into memory if a query is issued against it. This will save RAM resources in the cloud and limit the databases and views one has to filter thr...
about 1 year ago in Jedox Platform / In-Memory DB 0 Future consideration