2 Replies Latest reply on Apr 12, 2013 3:30 PM by gtmbanerjee

    Materialized View Loading

    gtmbanerjee

      Hi,

      We are having materialized view which are loaded when the first request hits the materialized view. We are thinking it is logical for teiid to load the materialized views

      after booting, as the materialized views have been defined to preload the data. If possible there can be a tag or switch which will turn the preloading on or off.

      Please let us know your thoughts on this.

      Thanks

      Gautam

        • 1. Re: Materialized View Loading
          rareddy

          Gautam,

           

          You can load the Materialized views through "execute SYSADMIN.refreshMatView(...)" call. In the Teiid engine, since the operations are occurring in asynchronous manner is difficult to schedule these jobs automatically at start. So, all you need a simple scheduler to execute above command.

           

          You can submit a feature request if you want, then we can determine that is feasible.

           

          Ramesh..

          • 2. Re: Materialized View Loading
            gtmbanerjee

            Thanks. We are already doing that. I will submit a feature request.