In SharePoint 2013, documents will now be stored in the databases in pieces, which makes it possible to update only a part of the document by updating one or more pieces in the database – instead of updating the whole document.
How It Works in SharePoint 2010:
When a file is updated, only the bits that have changed are sent from the client to the SharePoint WFE. However, because SharePoint lacks the concept of incremental updates to SQL it is forced to:
When a file is updated, only the bits that have changed are sent from the client to the SharePoint WFE. However, because SharePoint lacks the concept of incremental updates to SQL it is forced to:
- Pull the entire file to the WFE
- Merge the changes into it
- Write the entire file back to SQL
How It Works in SharePoint 2013:
- The file is broken into pieces and stored in SQL
- On update only the shredded blobs that correspond to the updated bits are touched
- No more round tripping entire files to the WFE and back
SharePoint 2010
SharePoint 2013
