Add database indexing for performance optimization #40
Description
Which feature are you enhancing?
Database query performance
Why is this required?
As the application grows with more users and messages, query performance will degrade without proper indexing. Adding strategic indexes will significantly improve response times for common operations like message retrieval and room filtering.
Any additional context?
Focus on adding indexes for frequently accessed fields like Chatroom.lastActivityAt, Message.timestamp, and composite indexes for pagination queries. Benchmark performance before and after implementation to quantify improvements. Consider implementing query monitoring to identify future indexing needs as usage patterns evolve.