currently, the mongo database collections in the project do not explicitly create indexes for frequently queried fields. This can negatively impact query performance and, in some cases, data integrity where uniqueness is required. It is important to review the main collections, identify which fields are most commonly used in queries, filters, and sorts, and implement the creation of appropriate indexes. Ideally, each collection class should ensure its indexes are created during application startup, so that the database is always optimized for the expected workload
currently, the mongo database collections in the project do not explicitly create indexes for frequently queried fields. This can negatively impact query performance and, in some cases, data integrity where uniqueness is required. It is important to review the main collections, identify which fields are most commonly used in queries, filters, and sorts, and implement the creation of appropriate indexes. Ideally, each collection class should ensure its indexes are created during application startup, so that the database is always optimized for the expected workload