You can translate the question and the replies:

Full Caching mode

Hello, I am trying out full caching mode and I am using a API from whcih I am calling data and I cannot store last refresh date in it. Can you let me know if still I can use Full caching as it fully suits my requirement.
user
16-10-2020 02:19:57 -0400

1 Answer

Hi, I enabled Full Cache over a view and cached the data. Now, when I execute the cached view, the data of the view is always retrieved from the cache database instead of from the source. In case if I want to retrieve latest data from the underlying data source which is not cached when I refresh my cached view. There is an Incremental option under Full cache mode which is only supported for views that meets the '[Requirements a View Has to Meet to Support Incremental Queries](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/cache_module/cache_modes/incremental_mode#requirements-a-view-has-to-meet-to-support-incremental-queries)' section in the Incremental Mode of Virtual DataPort Administration Guide. Reading your description, I believe that you do not have any field to indicate when the data was last updated, in that case, only full cache with periodic refresh would be best choice. For more details, you can refer to [Full Mode](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/cache_module/cache_modes/full_mode#full-mode) section of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
16-10-2020 07:41:32 -0400
You must sign in to add an answer. If you do not have an account, you can register here