Simple PHP and MySQL optimization method "Becoming special by accumulating common sense"

Last load MAX, server is on the verge of collapseIt is the page I found when I thought that it may be necessary to optimize on my own in the end.

We are gathering only the basic countermeasures of how to lose the same way when doing the same processing in MySQL or PHP. Everything is already here and there, but it is easy to read because it is gathered in one place. Some may not even know that.
Dublish.com - Simple Optimization for PHP and MySQL
http://www.dublish.com/articles/10.html

Those written in MySQL seemed to have read themselves a lot, but many people like PHP are likely to be told if they are told. There are various useful opinions in the comment section on the above page, so it's fun to go forward.

By the way, it was a certain program of NHK before, and now when I was young people who became a famous patissier, I asked about 3 years or so and finally worked in a shop with a famous three star patissier become,

"What wonderful recipe is to make such delicious things?"

I thought it was exactly the same as the recipe I learned when I went to a vocational school in Japan.

"Why is this taste different even though it is the same recipe? Well! The material is different!"

I was thinking that one day I was asked to buy, where I went to buy a neighborhood market or supermarket. In other words, I made it with a recipe everywhere, a material everywhere, it turned out to be a completely different taste, it was said to have received a shock.

As for what it is different this way, there are only details of how to make it. I noticed something as a result of continuing to observe instructions and fine movements issued every day there. Faithful to the basic as all actions are frightening. In other words, we carefully remove the damaged material and do not use it, cook it accurately, measure the amount accurately, do not set the temperature every time exactly, set the recipe, skip the recipe procedure completely, Make it on the street. The little disciples who burned too much did not put out the store and the disciple who burned that cake was instantly fired. In other words, we did not overcome anything, just just keeping the foundation and basics perfect.

"Becoming special when accumulating commonplace"

Surely it seems that everyone else is doing the same things as servers, programs, scripts, etc.