Applying query cache on freq. updated table

[nico]

Hi

I expect a lot from the mysql query cache as my tables are mainly used for SELECT.

However, I do some unimportant updates (counting the number of visits), but on a regular basis. Unfortunately, mysql flushes the cache when I make an update.

As a way around this, I could create a copy of each table that I want to have cached.

time t: copy table my_table to my_table_cache

after: apply the updates to my_table, and the selects to my_table_cache. selects will be fast using mysql query cache. They may correspond to old data, but I dont care.

time t+1: copy table my_table to mytable_cache and flush query cache

etcetera.

Is this a good idea, or is there a way around this?