Mysql - can I have a View that is an in memory image of a table

I have a table with about 3000 records that I query often.

Does mysql provide some sort of View that can load the table in memory and stay synced with my table 开发者_运维百科(similar to a cache), so i can query this view and have really fast results?

---

I wouldn't think a view would help unless the underlying table were also in memory, which you can ensure by creating it thus...

CREATE TABLE t (i INT) ENGINE = MEMORY;

13.9 of the reference manual has the details.