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: databases
Backups: a bit of insight and perspective.
Many of us have backups. Many of us don’t. Here’s an interesting question though. Those of us that have backups. How many have actually tested them out to make sure they’re working? If you have, how often do you test them? Most people set up a backup solution and just let it run. They don’t…