How to wisely use an update query

As we all know Update is the most expensive SQL query, Hence it should be used wisely. As if you did not care about the data-set, optimization, and performance before writing the query you are definitely going to be screwed!!! Here I have mentioned a recent case and a few experiments that I have gone…

Read More
30 / Sep / 2019

Optimize MySQL Queries with Indexes

I have been recently got stuck with slow SQL performance in one of my project so after searching a lot and with personal experience, I came across few sorted steps that helped me to keep good health of my SQL queries and made it faster. So here I have mentioned the brief from what I…

Read More
19 / Aug / 2019