Flexviews 1.7.1 / 1.8.0 beta1

Support for materialized views in MySQL
Materialized views are basically cached results for MySQL results.

When a query is executed in a MySQL database, the result is returned as a dataset stored in a virtual database table which later gets deleted.

With materialized views, the result of a MySQL query is actually stored inside a real database table.

This can be done with common queries for improving query speed, because the result will be read from the database and not compiled on every query.

Flexviews allows creating materialized views, and also additionally adds methods for refreshing the cached results so when database content changes the cache won't serve outdated results.

last updated on:
December 13th, 2012, 23:59 GMT
price:
FREE!
developed by:
Justin Swanhart
homepage:
flexvie.ws
license type:
LGPL
operating system(s):
Windows / Linux / Mac OS / BSD / Solaris
category:
C: \ Database Tools

FREE!

In a hurry? Add it to your Download Basket!

user rating 1

5.0/5
 

0/5

What's New in version 1.8.0 beta1
  • The refresh algorithm for views without aggregate functions has been changed to take into account the order of changes in the database.
  • All table changelogs now include a fv$gsn column to support the improved refresh algorithm.
  • FlexCDC is improved to support all datatypes.
read full changelog

Add your review!

SUBMIT