What are the disadvantages of the MYSQL view? When to select the view and when to select the storage process?

what are the disadvantages of views in MYSQL?

when can I use the storage process?

Almighty codeshelper, give me strength.

Jan.21,2022

stored procedures are not recommended. Although they are more efficient, they are difficult to debug and expand, and there is no version control. No one wants to operate database dynamic stored procedures when changing a method. If it is much easier to implement
views with code, it depends on the specific situation. If your database tables change frequently, do not use views

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e41654-4490c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e41654-4490c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?