Good morning wonderful people, I am a beginner in development and I have a question that has taken away my sleep, I am testing a system in php with database mongoDB, in which is generated a graph with metrics of all registers of mongodb (quantity of registers + - 700K), metrics like, which device used, gender, which link clicked, which email provider among others. this has taken forever to generate the graph, after some test I am sure that the speed is caused by php, to get a very large amount of records. Does anyone have an idea how to improve this performance? remembered that the data is captured after a person navigates my site (there are at least 100 new regitros per day).
Remembering, I already tried to cache a cron job with only the relevant data, and even then the amount is huge.
Thank you!