Archive for the ‘optimization’ Category

How to Optimize MySQL: Indexes, Slow Queries, Configuration

Posted on: No Comments
MySQL is still the world's most popular relational database, and yet, it's still the most unoptimized - many people leave it at default values, not bothering to investigate further. In this article, we'll look at some MySQL optimization tips we've cove...

The Theory of Constraints in PHP

Posted on: No Comments
I had been reading The Phoenix Project, a great novel about IT (you read that right), which presents day to day IT and devops problems at a large Amazon-like company in a way which makes mortals understand the complexities and chaos of 21st century tec...

How PHP Executes – from Source Code to Render

Posted on: No Comments
Inspired by a recent article on how Ruby code executes, this article covers the execution process for PHP code. Introduction There's a lot going on under the hood when we execute a piece of PHP code. Broadly speaking, the PHP interpreter goes through ...

Beaver in Action: Practical MySQL Optimization

Posted on: No Comments
Clients with an existing application sometimes ask me to fix bugs, improve efficiency by speeding up the application, or add a new feature to some existing software. The first stage of this is researching the original code – so-called reverse enginee...

6 More Must-Do Grav Tweaks: Ready for Hacker News Traffic!

Posted on: No Comments
We previously looked at some essential Grav plugins with which to round off the installation of a personal blog. In this post, we'll take a look at some additional, advanced plugins, as well as other tweaks we can apply. Related Pages Once a blog has ...