SharePoint is a database driven product and makes frequent database trips for almost all of its work. Most of what is shown to the user is either a list or a document (also called a BLOB) and both come from the database.
As a result, SharePoint performance is often not very good (slow response times). Slow response times can frustrate users and in case of customer facing applications, you can even lose customers and as a result direct revenue.
The SharePoint performance problems occur primarily due to the two reasons:
Figure 1: SharePoint deployment with performance bottlenecks
As you can see in Figure 1, the Web Front End (WFE) servers are frequently going to the SQL Server cluster for meta data, list content, and BLOBs. On top of this, Index Server and Query Servers are also going to the same database. The entire database is overloaded and slows down quite a bit. That is the reason why in typical deployments SharePoint performance cannot scale beyond 6-7 WFE servers in a load-balanced web farm.
So what's the solution?...............Externalize BLOBs and Use Caching
What you need is better SharePoint performance with faster response times even as your increase the number of users or number of WFE servers in the web farm. Better SharePoint performance results in satisfied users and an increase in revenue or website loyalty if your application is customer facing.
You can dramatically improve SharePoint performance if you use a few of intelligent techniques. They are:
Figure 2: Better SharePoint Performance with externalized BLOBs & Caching
Figure 2 shows how by using a combination of external BLOB storage (EBS) and in-memory caching, you can dramatically improve not only SharePoint performance but keep this good performance even when you increase user/transaction load on your SharePoint deployment.
The database trips are now made only to read lists once and then they’re cached for a configurable period of time so you don’t have to make these expensive database trips for lists again. Additionally, BLOBs are moved out of SQL Server and therefore all BLOB operations no longer go to the database. And, on top of all this, in-memory caching is used on both BLOBs and Lists which improves access time from WFE server to the cache and results in better SharePoint performance.
Few third party products are also available which can dramatically improve SharePoint performance and scalability.. You can find an example of the same products on this link www.alachisoft.com/.../index.html
Improve reading files performance for SharePoint 2010 / Tăng hiệu suất đọc file cho SharePoint 2010 sharepointtaskmaster.blogspot.com/.../improve-reading-files-performance-for.html