Level: Intermediate
In this session you'll learn how to design your databases so that they perform at their peak efficiency.
Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally, you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.
You will learn:
- Understanding why datatypes matter
- Awareness of performance problems associated with poor datatype design choices
- Solution options to fix performance issues caused by sub-optimal design choices