Why database should be taught before programming in universities?
Learn Database before Coding Often students from the initial semester ask me how do we store our data in our programming projects? When students join university to learn about computer science and technology they are usually taught programming fi ...
MySQL Installation and Configuration
A step by step guide on how to install and configure MySQL on the Windows Operating System.
MySQL Query Cache
MySQL query cache is good to cache select queries and their results and improve some performance of your database applications. So, enable query cache in just one step.
Multiple MySQL on single host
Sometimes we need to run multiple MySQL servers on single machine. That is mostly required in testing environments to test different aspects with different configurations. In this way one can test server without affecting others. So, if you want to r ...
Breaking problem into code
Improve the performance of your application by implementing correct logic for a particular problem.
Database indexes and locks
It is important to create good indexes so that your queries do not unnecessarily need to scan many rows, that can result in lock on those rows and due to which deadlocks can occur, performance can be degraded, or anything bad can happen.