AppFabric Caching – Proper use of DataCacheFactory and DataCache

Here is the answer from the forum post: Hi. Sorry for the delayed response, but I want to say that these are great questions and will probably be useful to others. There shouldn’t be a need for more than one DataCacheFactory per thread unless you are requiring different configurations. For example, if you programmatically configure … Read more

Redis vs MemoryCache

MemoryCache is embedded in the process , hence can only be used as a plain key-value store from that process. An seperate server counterpart of MemoryCache would be memcached. Whereas redis is a data structure server which can be hosted on other servers can interacted with over the network just like memcached , but redis … Read more

How can I invalidate the file system cache?

At least on Windows 7, it seems that attempting to open a volume handle without FILE_SHARE_WRITE sharing permissions causes the file system cache to be invalidated, even if the creation fails. Thus I made a program that simply calls CreateFile to this end. Download the program* from its Base64 version here: <!– Click “Run Snippet”, … Read more

Speed of mysql query on tables containing blob depends on filesystem cache

The design of BLOB (=TEXT) storage in MySQL seems to be totally flawed and counter-intuitive. I ran a couple of times into the same problem and was unable to find any authoritative explanation. The most detailed analysis I’ve finally found is this post from 2010: http://www.mysqlperformanceblog.com/2010/02/09/blob-storage-in-innodb/ General belief and expectation is that BLOBs/TEXTs are stored … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)