I'have a mysql view that is taking a bit too long, I know i can set a cache globally with mysql but I want to cache only one specific view is that possible ?

CodePudding user response：

You cannot cache a view but you can create a table that would save that record permanently.

You will be able to access the same dataset without waiting for the execution of the conditions of the view.

CREATE TABLE my_view_cache as SELECT * FROM my_view;