Hey, I am implementing a pagination query which contains huge data from different collection(s). I have used lookup for joining the data. The problem I am facing currently is that, When I perform count operation on the data it takes around 1s40min. Is there a way to perform pagination count in less time.
Looking forward for the reply
Thank you!