Tuning

We’re being told over and over that “throwing hardware at the problem” is not the correct solution for performance problems and a 2x faster server will not make our application twice as fast. Quite true, but there’s one thing that we can do very easily without emptying the piggy bank and won’t hurt for sure: buying more RAM. The price for server-class RAM has dropped so dramatically that today you can buy a 16 GB module for around € 200. [Read More]

One byte at a time, obviously! No elephants were harmed during photoshopping. Sometimes, when you have to optimize a poor performing query, you may find yourself staring at a huge statement, wondering where to start. Some developers think that a single elephant statement is better than multiple small statements, but this is not always the case. Let’s try to look from the perspective of software quality: Efficiency The optimizer will likely come up with a suboptimal plan, giving up early on optimizations and transformations. [Read More]