MySQL 8.0 - View Performance

[dino cummings]

I've got a fairly complex view - multiple views feed into one view. The views that feed into the final view are fine. The performance is decent, and to be honest, there is not a lot of data, but when I try and join the views into the final view, the performance dies.

I'm assuming it's choking on the complexities of the multiple views. Is there anyway, I can get it to return the results of the views that feed into the final view without it trying to workout all of the view script?

I'm not new to MySql, but definitely new to 8.0. I apologize if this comes across as a newbie question.