[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1155
  • Last Modified:

MySQL, snapshot or materialized view

Hi: In Oracle, if one has long time consuming SQL, one could make a snapshot view or materialized view. That is to say, to generate a view every hour or a day to avoid real time large amount of database SQL manipulation. When user hits the link, the snapshot or materialized view would be fetched so that time is saved. I am wondering in mySQL, are there similar feature? Where is the link?
0
JianJunShen
Asked:
JianJunShen
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
there is no matching thing...  at least not for the "query rewrite" features... making some query to use automatically the mv instead of the table...
however, you can always create a table from a query on regular intervals, however any query should need to use that table explicitly

0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now