MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jon Frisby Date:October 21 2005 5:11pm
Subject:RE: Input on Materialized Views
View as plain text  
> Better, mark this view (or particular rows if it's not too 
> expensive) as "dirty" and recompute it only on access, you 
> may spare few cycles...

That sort of depends on what you're going for.  Typically materialized
views are used for summarizations of hypercubes for OLAP systems (data
marts / data warehouses).  You want access to these views to be as fast
as possible as they're often accessed by interactive programs (reporting
UI).

Recomputing when the change happens is desirable because slowing down
that change just a tiny bit generally won't be a huge deal, as the thing
doing the change is going to be your ETL process which is generally
non-interactive anyway.

-JF
Thread
Input on Materialized ViewsAndrew Roth19 Oct
  • Re: Input on Materialized ViewsJigal van Hemert19 Oct
    • Re: Input on Materialized ViewsSGreen19 Oct
      • Re: Input on Materialized ViewsAndrew Roth19 Oct
        • Re: Input on Materialized ViewsSGreen19 Oct
          • Re: Input on Materialized ViewsAndrew Roth20 Oct
Re: Input on Materialized ViewsHeikki Tuuri20 Oct
  • Re: Input on Materialized ViewsPooly21 Oct
RE: Input on Materialized ViewsJon Frisby21 Oct