Search code examples
sqlmysqlmaterialized-viewssql-view

Materialized views with MySQL

Emulated materialized views with MySQL has good performance? I'm learning how to do with this link

thanks

Correction: "Materialized views" to "Emulated materialized views".

Solution

  • MySQL doesn't have materialized views - the link just creates a table and stuffs data into it so the table can be indexed. That means the performance is par with a normal table, but you also have the overhead of flushing & repopulating the table (including indexes).

    I didn't see what engine the table was using, but MEMORY would likely be a better choice.