# Semantic modeling

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.

{% embed url="<https://www.youtube.com/watch?v=l3CmGKzLIXo>" %}

### 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&#x20;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.infotopics.com/writebackextreme/features/management-console/semantic-modeling.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
