CVS account change in Eclipse
Replaced the CVS account in all CVS meta files in the whole project hierarchy in Eclipse.
Muhammad Jawaid Shamshad
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…
Why code bad instead of clean code?
It is unprofessional for programmers to bend to the will of managers who don’t understand the risks of making messes and bemoan the schedules that were too tight to do things right.
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.
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.
Referential Integrity
Always use referential integrity constraints. There is no reason for not using it.
Common coding pitfalls developers should avoid
If result of a function is needed more than once then don’t call that function multiple times. Save the result of that function in a variable and use that variable instead.