Tag DB design

Linux, Microsoft, MySQL, Technology, Windows

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.

Muhammad Jawaid Shamshad
April 17, 2009

MySQL, Technology

Many-to-many relationship

When designing an application or database, also consider other scenarios and pros and cons of the approach being adopted, not only one scenario. In other words if one approach is solving your problem then also consider what other problems we can face due to it, and prepare for those as well.

Muhammad Jawaid Shamshad
April 2, 2009
1 Comment