MySQL VIEW as Performance Troublemaker

I start to see applications being built utilizing VIEWs functionality which appeared in MySQL 5.0 and quite frequently VIEWs are used to help in writing the queries – to keep queries simple without really thinking how it affects server performance.
Even worse than that – looking at the short table which just gets single row […]

Read more