Archive for February, 2010

Simulating a Materialised View in mySQL

Thursday, February 18th, 2010

As mySQL does not support materialised views out of the box, I was looking for a work around. The most convincing one I found (because it only switches tables when the new one is readily filled) is:

  1. create your view v_name as
    [...more...]