There are currently several models in the backend querying on them that have some common search fields, which can be optimized by adding simple and compound indexes to them. The issue came up as an idea from one we encountered in IIT-BHU-InstiApp/lite-hai-backend#81. The attached PR that I made can be taken as a reference even though people might not know about indexes, but the selection of what indexes to make simple and compound both should be justified based on their frequency in search.
There are currently several models in the backend querying on them that have some common search fields, which can be optimized by adding simple and compound indexes to them. The issue came up as an idea from one we encountered in IIT-BHU-InstiApp/lite-hai-backend#81. The attached PR that I made can be taken as a reference even though people might not know about indexes, but the selection of what indexes to make simple and compound both should be justified based on their frequency in search.
Required Skills :