DONE: Force dbFront to load a fresh copy of the data everytime.

+1 vote

We have tables, some with views that need to load a fresh copy of the data every time the user uses them in a lookup or elsewhere.

The issue is that we update these tables externally and dbFront does not recognize the updates because sometimes it is working with cached data. This shows up in multiple places:

  • When using fields from the Profile Table in the page headers,
  • When using dropdowns/lookups,
  • When editing other records on the same table grid.

It would be great if we could force dbFront to always load fresh data for these tables.

in Features (Done) by (7.0k points)
retagged by

1 Answer

0 votes

As of dbFront, you can now disable the caching on specific tables. dbFront will then make extra efforts to always load fresh data for those tables in all situations.

This obviously has performance implications as dbFront is forced to return to the database and reload the data for that table everytime a screen is reloaded.

This table level CacheControl, is in addition to the previously existing Force Server Lookup flag that is available on Lookup fields.

Any changes to the table setting takes effect immediately.

by (64.5k points)
edited by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer