123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computer-Programming >> View Article

Sharepoint Application Avoid Performance Mistakes

Profile Picture
By Author: Denis Richard
Total Articles: 18
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

A fast developing Microsoft platform, SharePoint, has come-up a long way from document management app to application development platform. SharePoint has also grown from utilizing ASP.NET to develop its own API and manage contents in SharePoint Content Database. Though many things have changed, for the good but some still needs attention. Some Companies have implemented their own solution based on SharePoint while others are still in waiting list.

SPList Items’ Iterating: Use this list from current SP context or create a SPList object to access a list identified by its name. It provides an Item’s property that returns a SPList Item collection object. The problem is Item’s property queries all items from content database for present SPList and does so every time the item’s property is accessed. This means that retrieved items are not cached. This problem of execution of same SQL statement and retrieving all items from content database can be solved but is unfortunately looked over.

Too-much Data request from Content database: When there is a request to access data from content database using the SPList ...
... object; then user ends-up in requesting all-items of the list. Developers usually go directly to SPList and work to retrieve list items resulting in excess data retrieved from Content Database. The best way to solve this problem is to use the SPQuery object and its features for limiting elements and columns.

SPSite and SPWeb Memory Leaks: The COM component is used for some of the core features of SharePoint. Though theoretically there is nothing wrong with COM, yet there is memory management of COM objects. SPSite and SPWeb are used to gain access to Content Management by the developers. Such objects need explicit disposal to release COM objects from memory when these are not needed. As SPSite and SPWeb are not disposed; so SharePoint installation runs into problem. The ASP.NET Worker Process leaks memory and the user ends-up in program being recycled by IIS in case the person runs out of memory. Recycling is related to losing current user session and paying a performance penalty for users who hit the worker process again after recycling is over.

The right approach is to monitor program for its memory usage and whether there is any memory-leak or not. Special memory profiler can be used to identify the leaking objects and what factor is leading to leakage. Special tool called “SPDisposeCheck” is used as a tool to detect SPSite and SPWeb leaking objects.

Denis Richard is a professional technical writer who has expertise in web application development, web applications, sharepoint application development.

Total Views: 342Word Count: 429See All articles From Author

Add Comment

Computer Programming Articles

1. Custom Laravel Web Development: Why It’s The Smart Choice For Your Business
Author: Adarsh

2. Best Web Development Institutes In Bhopal Offering Java Courses
Author: Rohan Rajput

3. Top Web Development Institutes In Bhopal For Java Coding Classes
Author: Rohan Rajput

4. Why Every Business Needs Online Accounting Software In Zambia 2025
Author: Doris Rose

5. Best Web Development Institutes In Bhopal For Java Coding Classes
Author: Rohan Rajput

6. Master Ai Skills With Industry-leading Certifications
Author: EDCHART

7. The Ultimate Guide To Equipment Rental Software
Author: prestartr

8. The Enduring Importance Of Websites In The Ai Era
Author: Backend Brains

9. Ibm I Security Risks & Best Practices: Protecting Your System In 2025
Author: Siddhant Saxena

10. The Ultimate Guide To Top Web Development Institutes In Bhopal
Author: Rohan Rajput

11. What’s New In Laravel 12 – Features, Updates & Upgrade Guide
Author: espirittechusa

12. Discover The Best App Development Company In Bangalore For Your Next Project
Author: Gaurav Kumar

13. How To Choose The Right Web Development Institute In Bhopal
Author: Rohan Rajput

14. How Digital Publishing Solutions Improve Content Distribution?
Author: tribotz

15. The Evolution And Relevance Of Ibm I (as/400, Iseries) In Modern Business
Author: Siddhant Saxena

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: