Coding with SharePoint? Things you should not do
Often there are multiple ways to get what you want. E.g. if you want to get a listitem, you could user list.GetItemById() or list.Items[x].
sowmyancs has posted an excellent article about performance for certain tasks –> Best Practices: SharePoint Object Model for Performance Tuning