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!

This entry was posted on January 22, 2007 at 12:00 AM and has received 4030 views. There are currently 1 comments. Print this entry. Download attachment.