Performance
All SWE patterns tagged with Primary Impact: Performance
Missing Indexes on Frequently Queried Columns
Failing to create indexes on columns used in WHERE clauses, JOIN conditions, or ORDER BY statements, causing full table scans that degrade exponential...
Over-Normalized Schema with Excessive Joins
Taking database normalization to an extreme where data is split into too many tables, requiring numerous joins for basic operations. While normalizati...
Cache-Unfriendly Schema Design
Schema designs that prevent effective caching strategies, causing database overload under normal operating conditions. This includes mixing frequently...
Unbounded Social Graph Queries
Implementing social relationships using pure relational joins without considering the exponential growth of multi-hop queries. Simple adjacency list t...
JSON Blob Misuse in Relational Database
Storing significant structured data as JSON blobs inside relational database tables instead of using proper columns and relationships. While modern da...
Poor Data Partitioning and Hotspot Keys
Designing schemas without considering data distribution, either keeping everything monolithic or choosing partition keys that create severe hotspots. ...
Unbounded Growth (No Data Archiving)
Allowing tables to grow indefinitely without archival or cleanup strategies. Common with logs, audit records, and historical data where the assumption...