Issue Details

The analytics dashboard often takes over 20 seconds to load, particularly when displaying historical data. Queries are not optimized and are fetching unnecessary records. Indexing improvements and pagination could help improve performance significantly.