1.9.2.Data Tier

• Schema issues

  • Primary keys

  • Relationships

  • Indexes

• Entity-Attributes-Value

• Problems with EAV pattern

  • No O/RMs

  • Long, gigantic queries

  • Extremely slow

• Optimizing queries

  • Use Execution Plan in SQL Server

  • Create a "read" database (look up CQRS)

  • Use caching