In-memory means that the data is stored in the memory of the web server instead of in the database server. This allows for faster data access by the user.
The example below showcases the regular process (the database server is used). The following four steps will occur when a user, for example, selects a filter in a dashboard and clicks update:
By using the In-memory model, the necessary data is stored in the memory of the web server. This results in less steps to process the requests, as shown below.
As shown in the image above, there is a Status label that indicates if the in-memory model has been updated or if it still needs to be updated. The in-memory model needs to be updated as soon any change has been made that effects the data. For example, this happens when computing a new variable, creating a grouped answer, updating the hierarchical filter structure, and so on. You don’t need to remember which actions force an update, as the system clearly indicates if the in-memory data model needs to be updated.
As soon as an update is needed, a warning message will appear at the top of the page, as shown in the image below. To update the in-memory model, simply click “Update” in the message. If the data model is not updated, then your reports will show “old” data, so it is important to upload the model at least before the report users enter the portal.
The In-memory data model is automatically updated when data is activated and when a pre-generation is started (if the In-memory model needs to be updated). Therefore, you only need to care about updating the model when you are making changes in your portal. You don’t have to do anything in, for example, a tracking project which is continuously loaded with new data.
The In-memory storage of metadata and report settings can be activated in the Project settings page by ticking the options that are highlighted in the image below. The image below shows the options to tick to activate In-memory storage of metadata and report settings.
As shown in the image above, a Status label indicates if the In-memory model has been updated or if it still needs to be updated. The metadata In-memory storage needs to be updated as soon as a question text, answer text, question color, etc. has been updated. The report settings In-memory storage needs to be updated as soon as a change is made in the StoryTeller.