I used to spend long hours staring at screen and running load test again and again to reduce the latency of that problematic API. Then, doing some small changes here and there and relying more on God than myself for miraculous improvement. Can you connect to this? Voila! I learnt EXPLAIN. I am going to shareContinue reading “Why should we use explain command?”
Tag Archives: database optimization
Optimizing MySQL Performance – An Introduction
What can a badly designed database do? Anyone whose bread and butter comes from database seldom underestimates database performance. But Paulo Cohelo said in veronica decides to die that, People never learn anything by being told, they have to find out for themselves. Echoing the similar sentiments, I was happily having breakfast, lunch and dinner until oneContinue reading “Optimizing MySQL Performance – An Introduction”