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: application
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…
Database Backed Web Applications Advice
Here’s the scenario. You’ve got a dedicated server running windows in a server farm (generic dedicated server provider). You have mysql + asp or php app running all on the same server. Raid 1 mirroring and 2 GB of ram. You have to have windows, because your application supports it. Sound Familiar? It’s a problem…
n-Tier Architectures what they are in a nutshell
If you’re in Enterprise IT, you’re going to hear one buzz-word a lot. The buzzword? 2-tier Architecture or 3-tier architecture. I like to refer to it as n-Tier architectures. So what exactly is it and what does it mean? A Tier in an architecture is simply the number of layers of an application or system…
Redundant Application and Database Infrastructures
Most people don’t backup their databases, much less set up redundancy. It’s an important thing to consider when your application / website just cannot go down. This article discusses what it will take to set up that type of redundancy and I will be following up with a document on how to do it in…
How to Bind utorrent to a specific ip and route it out a vpn for better speed. [Solved]
Torrent technology is an amazing in the sense it uses swarms of users to serve and share files you may be trying to download. It’s been implemented by many companies and is a very bandwidth efficient format to get your files served to you faster. Whenever I download CentOS DVDs, I use utorrent and other…