I found out that it seems flush from memory very soon make it unable to use the cache data, results in slow to getting results.
1) How long will it cache the data?
2) Any setting can be set for the interval of caching?
3)Any hot fix /patches in SQL2012 to solve this issue?