mysql Archives - Coding Dude

mysql materialized view with scheduler or trigger

Materialized Views In MySQL And MariaDB

June 15, 2018May 13, 2019Databases4 Comments

You can implement materialized views in MySQL. How? Read this post and I will show you 3 different methods for creating a MySQL materialized view. 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 retrieval...

Creating a PHP MySQL pie graph

April 23, 2014April 17, 2019PHP5 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...