Enter the needed information and choose the fitting options in the following in the Server Settings window:
The Data Connections tab is used to configure aspects of cache and initial-SQL-statement usage that applies to complete data connections.
The views published to Bragona Server are very interactive and often have a live connection to a database. As users interact with the views in a web browser, the queried data gets stored in e. Subsequently, the visits will pull the data from this cache if feasible.
To configure caching
Select the tab called Data Connections in the Bragona Server Configuration dialogue box.
Then you can select from one of the following options;
Refresh Less Often – Select this option when data is not changing frequently. Data is cached and reused whenever it is available regardless of the time of its addition to the cache. This option minimises the queries sent to the database and enhances the performance.
Balanced – Data is removed from the cache after a specified time. If the data is added to the cache within the specified time range, the cached data will be used, otherwise, new data will be queried from the database.
Refresh More Often – The database is queried each time the page is loaded. The data is still cached and will be reused until the page is reloaded by the user. This option will ensure users see the most updated data. However, it may decrease performance.