PINAHA

like humans, the database is a friend who obeys and understands at every command given, unfortunately sometimes not be otherwise, we are not obedient and do not understand the “orders” given database.
Databases can sometimes be “scolded” by a variety of ways, could be in the form of declining performance, error messages, or even results that are not appropriate reports. All of them can be minimized, even before it happened.

SQL and RDBMS
Optimization can be done in various ways, with the understanding of database performance tuning and best practices from various sources; you can have a strong fundamental in optimizing database performance.
Some of the techniques and methods may require special treatment different, depending on the database you use.
For example, performance improvements can be done from the administrative database like configuration file and self-service or security update pack, which of course each database has its own uniqueness and techniques.

Then, with consideration of compatibility, is there any optimization that can be done in general? Read more…