I took this example from a book where visitors_today is the cache table from visitor_stored. The idea is to store all the visitors per day (visitors_stored) using a cache table.
Create table visitors_today( today int unsigned not null default 0, vcount bigint unsigned not null default 0 ) engine = Innodb; create table visitors_stored( v_count bigint unsigned not null default 0, vcount_date DATE not null primary key ) engine=MyIsam;
- Do I need to set up something?
- A cache table is it just a regular table, the difference is the data will be delete after update the visitors_stored?, or just because the storage engine it will be faster?