mysql Archives - Coding Dude

mysql materialized view with scheduler or trigger

Materialized Views In MySQL And MariaDB

June 15, 2018July 27, 2018Databases3 Comments

You can implement materialized views in MySQL. How you ask? Read this post and I will show you several different methods for creating MySQL materialized views. An application is only as fast as it’s slowest component. If your application uses MySQL your objective is clear: Improve MySQL query performance to get faster data...

Creating a PHP MySQL pie graph

April 23, 2014November 9, 2018PHP5 Comments

How To Generate A Pie Chart In PHP MySQL Using The Infographic HTML Tags Library In this short post I’m going to show you how you can create a pie graph using the Infographic JS HTML Library based on data taken from MySQL. Some of the users of the Infographic Library have been asking...