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
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.