?
Solved

MySQL, snapshot or materialized view

Posted on 2009-04-06
1
Medium Priority
?
1,129 Views
Last Modified: 2012-05-06
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
Comment
Question by:JianJunShen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24081523
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question