Mongodb Best Practices

Priority: P0 (CRITICAL)

Guidelines

• Schema Design:

  • Embed vs Reference:
    • Embed (1:Few): Addresses, Phone Numbers. Optimization: Read locality.
    • Reference (1:Many/Infinity): Logs, Activity History. Optimization: Document size limits (16MB).
  • Bucket Pattern: For time-series or high-cardinality "One-to-Many", bucket items into documents (e.g., DailyLog).

• Indexing:

  • ESR Rule: Equality, Sort, Range. Order your index keys (status, date, price) if you query status='A', sort by date, filter price > 10.
  • Text Search: Use $text search instead of $regex for keywords. $regex is slow (linear scan) unless anchored ().