The biggest mistake you can make to cause problems with performance as a developer is to use joins. Inner or Outer Joins take up a lot of CPU. The transaction queries also take over 1000% time to complete in many cases. If you have to join tables, you need to revisit your DB architecture. The…
Tag: efficiency
The most common mistake in Applications and Databases in general
So many programmers make this mistake because they don’t seem to get it. It’s not your fault as a programmer / developer. It’s just that you’re not a DBA. You need to implement Connection pooling. It makes such a huge difference in the way your DB performance and app works it’s amazing. So here are…
Boosting Octane Yourself. I did the research, made it, and proved it.
So I drive a car that requires 93 min. Octane. Me, being the skeptic started thinking about Gasoline blends around the world. I realized in my travels (and I am extremely well traveled), that pretty much every other country in the world has one grade of Gas vs. America and some parts of Europe and…