In the code below, Name is set to a particular thing. If you run, and then re-run you'll get a cache hit. Which is as expected. However, if you change only the Name, the cache seemed to miss, which is unexpected.
Also, changing the name can cause one to have two entries in the hash database code for the query cache. I've also seen that in other circumstances (btw):
In the code below,
Name
is set to a particular thing. If you run, and then re-run you'll get a cache hit. Which is as expected. However, if you change only theName
, the cache seemed to miss, which is unexpected.Also, changing the name can cause one to have two entries in the hash database code for the query cache. I've also seen that in other circumstances (btw):