MySQL Forums
Forum List  »  Performance

MySQL 8.0 - View Performance
Posted by: dino cummings
Date: September 20, 2019 07:47PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 8.0 - View Performance
1089
September 20, 2019 07:47PM
709
September 20, 2019 09:14PM
321
September 20, 2019 10:29PM
341
September 20, 2019 11:18PM
359
September 21, 2019 12:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.