Precautions of sharepoint performance issue

1. Iterating through SPList Items
2. Requesting too much data from the content database
3. Memory Leaks with SPSite and SPWeb
4. Index Columns are not necessarily improving performance
5. SharePoint is not a relational database for high volume transactional processing

How to avoid the Top 5 SharePoint Performance Mistakes