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…
Category: Databases
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…
A Perfect Example of Disaster Recovery in the Cloud
Netflix went down yesterday due to power problems at Amazon’s Virginia Datacenter. This of course caused an outage for some of Amazon’s EC2 customers. (Like Netflix). This is a perfect example of why Redundancy in the cloud is important. All of my customers (some of them at EC2 Virginia) stayed up and available. How? Redundancy….
What happened to “Human” in Humanity?
I really do need to ask this question. I appreciate my followers and yes, they’re a loyal bunch. I do need to EVERYBODY one question and everyone on the Internet. We all go about our lives. We see the homeless person at the exit ramp, on the sidewalk, etc. Granted a lot of them are…
Free Tech Support from me…
OK. I really believe in my project for helping the unemployed, so here’s what I propose. If you donate to my project and of course, get others to donate to my project, I will provide you with free tech support (my skills and advice) for a period of time. Donate: $25.00 you get 1 hour…
I guess this is a call out for help
I’m at the point where I can’t support this blog due to the traffic I’m getting. I really need some donations or something. I’m pushing about 5 GB of data a day and due to my divorce, I can’t afford to support this continually. I’m not asking for donations, although, they would help, but I…
Imagine never having to pay for a server admin
For Small, Medium, and Large Businesses Alike I don’t know if many people realize what my various amazon offerings are so I thought I would spell them out. The toughest thing to do is not just set up a server, but to set it up correctly and keep it running. By signing up with me,…
Backups. Being prepared for the restore.
Backups are something that is so important in any system that one should look carefully at not just the backup solution they are using, but the restore solution they’re going to have. Here are my recommendations and views on Backups. 1. Don’t assume that just because you bought a backup package that it just “works”…
When was the last time you had a technology audit?
This is a message to everyone who runs any kind of technology in a business. The posting is directed towards everyone who has their own applications, servers, blogs, websites, etc. Special Note to CIOs/CTOs: I understand you run an organization that has many people under you. I understand that you feel you’ve got your resources…