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: Performance
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…
Nuveum offers Free High Performance Virtual Server for donating
It would seem that my Startsomegood.com project for helping the Unemployed is starting to gain some traction. Our first corporate Donator not only donated to the campaign, but decided to add an extra reward to my project. For anybody donating $10.00 or more, to the project for helping the unemployed, they get a free High-Performance…
The Virtual Webtop – A different type of experience
The Term Webtop has been a long time, but has been a fledgeling technology that has failed to take off. The reality is the technology wasn’t ready. In my honest opinion, the original creators had the right idea, but they got the whole concept wrong. So here’s where I’ve come to think about it on…
True Dynamic Path Routing
Everybody talks about BGP and assumes it’s as easy as just simply routing out the internet gateway. This is what most ISPs and Cloud providers do is just advertise their paths. A truly high-performance cloud provider will have multiple connections to multiple backbones and use ToS and try special paths to certain IPs. This is…
A review on Alix Boards for a Firewall
I know firewalls and have definitely tested and worked with many appliances. One of the most interesting and successful appliances out there seems to be the Alix board. These boards are built on Cheap chipsets (VIA) and cheap processors (Geodes). So here’s my reaction to them. (I own 3). 1. If you’re going to use…
Making Windows feeling like it’s a new installation
After realizing all the people I meet that have extermely slow installations, I thought I’d write a post / article on how to make / fix your windows installation to make it work like it’s a new computer. There’s really only 3 steps to doing this. 1. Download or Buy Auslogics Boostspeed and run the…
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…
Increasing Mysql performance significantly
For those of you who run mysql, there’s an issue that you have to look at. Like file systems, database tables get fragmented over time. There’s a simple fix for it, but you will need to execute one command to do it. Of course, you will need to have root access to your Mysql server,…