More often that not slow applications can be traced back to the database. This session would show ways to write more efficient queries, such as never using SELECT *, using EXISTS as opposed to IN, different join types, etc... I would also cover how things such as joins and subqueries can affect speed. The session would focus on techniques that could be used in most databases as opposed to focusing on only one. This session would be geared towards developers who know how to write queries but are looking for an understanding on how to write better queries.
Add this blog's RSS feed to your podcast player!