Microsoft® Office SharePoint® Server 2007 Administrator's Companion

Configuring Content Caching

One common theme across all SharePoint sites, including publishing sites, is that virtually all the content is stored in a Microsoft SQL Server database. The only content that’s not included in the database is the JavaScript, CSS, images, and some ASPX files that are common to all sites (such as the pages you see linked from Site Settings). For a publishing site, this means all images, style sheets, custom JavaScript files, and documents will be stored in SQL Server. Every time a page is requested, SharePoint will go back to the database to retrieve the content. This is an obvious detriment to the performance of the site because fetching data from SQL Server compared to pulling it from memory or off the local hard disk ...