3 Replies Latest reply on Mar 31, 2014 12:19 PM by Steven Hawkins

    Setting materialized view to be loaded at start time and not at first request and refreshed periodically

    luca gioppo Novice

      It seems to me that materialized view are generated at the first call to a VDB (at least the in-memory ones).

      It would be nice to have them loaded at VDB activation and refreshed after time-to live expiration.

      The option is to have the view refresh itself periodically so that there will be no wait time for the first user.

      This can be helpful especially for large data that does not vary much and can require complex transformation, but is not so much or frequently used.

      Having the option to:

      1) load at start time

      2) refresh at end of time to live without waiting for next call

      could be usefull

      Is it already possible?

      Is it reasonable?

      Thanks

      Luca