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 ?
>Solution :
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;