When you query a table, you have the option to check “retain rows”. I’m wondering when people use this, where the cache is stored, and when (if ever) the cache is renewed.
In our example, we have a rather big DB table of articles that I want to use to populate a dropdown list. This table is quite static, so I’ve disabled polling on it. And it also doesn’t depend on bindings from the UI.
I think that “retaining rows” would be a good option here, as then the query isn’t executed every time the window is executed.
But when does the data get updated? What happens after a few years, when the table contents may have changed a lot compared to the original data? Is the cache updated when new data is discovered, or will it always return the rows as stored in the designer first?