Should I use mysql views?

Question

MySQL

Hello everyone, in one of the old projects, I remember the proger used views in the mysql database, now every time I load a page, I need to take a range of dates from the database and perform various manipulations with them, then display all this on a chart, and such charts in each of which includes a dozen date ranges can be approximately 5-10, i.e. you need to do a lot of manipulations and calls to the database, I’m thinking that I can make such a view in the database in it to write the necessary logic with which it will collect data from tables and process them and then just make a call to it and output, so I’m not familiar myself with this tool and I ask you to tell me whether it is worth using views so that most of the work is inside the database or do it as usual on the server?

Answer 1

views is not a load optimizer, it's just an alias, roughly speaking. Code optimization yes, load optimization no.
And so and so the selection takes place inside the database
Is the database not on the server?