Optimise Database Query Performance #24
Description
Problem:
Controllers make multiple database calls where single queries could suffice. Chat and message endpoints don't use population or aggregation pipelines effectively.
Why it's an issue:
- Potential N+1 query problems
- Slower API response times
- Inefficient database usage
Acceptance Criteria:
- Implement proper populate queries in chat endpoints
- Use aggregation pipelines where beneficial
- Reduce number of database calls per request