The performance options on Project Settings page will improve the performance of the projects that have large data files or considerable number of objects across reports. These options should be enabled once you completed the project and just before releasing your project online. There are four types of performance enhancement settings that can be turned on in your project that will improve your portal speed.
1. The in-memory data model is turned on by ticking the “Activate in-memory data model” option in the Project Setting page. When activating the In-memory data model, the raw data is copied from the database server to the memory of the web server for faster access by the user. It may take from a few seconds to a few minutes to copy all of data.
The In-memory data model allows for significantly faster calculation of results in the StoryTeller and Cross Table Tool 2.0. The calculation speed depends on many factors such as the number of respondents, number of variables, what kind of results will be calculated, and more. Another benefit of the In-memory model is that the same result is never calculated twice. Once it has been calculated, it will be stored as a pre-generated result so that the results of certain reports and filter combinations are only calculated when viewed by the first user.
Note: InMemory data processing has to be enabled at all times in projects with more than 500,000 respondents.
2. Cached meta data allows for the faster loading of StoryTeller objects – it affects the loading of the object, not the calculation time of the result. You will benefit most from this setting if your project has a lot of variables and/or a huge hierarchical filter structure.
3. The cache storage of report settings allows for the faster loading of StoryTeller objects – it affects the loading of the object, not the calculation of the result. You will benefit most from this setting if you have a lot of objects in your report.
It is highly recommended to have the cache options (2 & 3) inactivated while editing the project as Admin. Once the project is ready and approved for distribution you may enable these options as well.