Semantic modeling

Since version 6.0, WritebackExtreme has evolved from a pure writeback engine into a data service that can also act as a data source for supertables.

The Semantic Model page lets you define a semantic model . This model is used by Supertables so it can query data through the WriteBack data engine. Use this feature to boost the performance of your supertables when using large datasets!

---

How it works

1. Create a semantic model in the Management Console.

2. Select the connection to your database.

3. Select the table you want to fetch the data from.

4. Save the model.

When opening the configuration of Supertables, you can select this semantic model as a datasource.

Caching

When using large datasets (e.g. > 10000 rows) WriteBackExtreme applies caching to totals and grand totals to avoid querying the database every time. Supertables already has a mechanism built in to update the totals and grand totals whenever it detects that data has changed. In specific use cases it would be beneficial to refresh the data more often. In this case