You can turn on the disk-based caching feature in IIS for your SharePoint sites. By default, this stores picture, video, and audio files on disk so that the files do not need to be retrieved again from the SQL server. This can greatly improve the end-user experience as large files are retrieved much faster. It also reduces the load on the SQL server having to send the file to the web front end server each time it is accessed.
To configure the Blobcache in IIS:
- Open IIS Manager
- Right click on your SharePoint site and click explore.
- Open the web.config file in Notepad
- Locate the line <BlobCache location
- At the end of the line, change the enabled=”false” to enabled=”true”.
- You may wish to configure the maxSize as well, this specifies the maximum size of the entire Blob cache.
It is recommended to set the location on the blob cache to a disk other than the disk you use for your server logs or paging file, so as to reduce issues that may arise due to disk contention.
For more information, refer to the following links: