Flexviews 1.7.1 / 1.8.0 beta1

Support for materialized views in MySQL

  Add it to your Download Basket!

 Add it to your Watch List!

0/5

Rate it!

What's new in Flexviews 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
send us
an update
LICENSE TYPE:

LGPL: GNU Lesser General Public License

USER RATING:
5.0/5 1
DEVELOPED BY:
Justin Swanhart
HOMEPAGE:
flexvie.ws
DATABASE:
MySQL
CATEGORY:
C: \ Database Tools
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

Runs on: Windows / Linux / Mac OS / BSD / Solaris

requirements

#database query #cache result #database cache #database #query #cahce #result

Add your review!

SUBMIT