Solved

MySQL, snapshot or materialized view

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
servlet and mdb, jms error 1 57
mysql db 3 81
Finding all private fields and their corresponding getters setters for nested classes 4 21
Coding for the first time 9 62
Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

756 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