Solved

MySQL, snapshot or materialized view

Posted on 2009-04-06
1
1,115 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 500 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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
converting integer data type to time data type in sql 4 60
EditableGrid how to fetch rows from MySql in php 14 70
Survey branching tutorial 11 75
Java List 4 74
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Creating and Managing Databases with phpMyAdmin in cPanel.
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
This video teaches viewers about errors in exception handling.

739 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