Solved

MySQL, snapshot or materialized view

Posted on 2009-04-06
1
1,092 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
1 Comment
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Creating and Managing Databases with phpMyAdmin in cPanel.
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This video teaches viewers about errors in exception handling.

763 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now