Flexviews allows you to cache (materialize) SQL statements and then quickly apply only the changes to underlying tables to update the cache. This can phenomenally increase the performance of your application and allow you to more easily maintain summary tables automatically.
I'll be demonstrating the usage of Flexviews and how to create 'fast refresh' materialized views.
I'll be showing off:
FlexCDC - Flexible change data capture for MySQL
Flexviews - Uses FlexCDC and stored procedures to incrementally maintain mateialized views, including those with inner JOINS and aggregation.
My SQL Dump
MySQL musings by a self professed MySQL Geek
- Check out my Flexviews talk in the Open Space today at 3PM.