Computer Science – Databases
Scientific paper
2012-02-15
Computer Science
Databases
Submitted to WSEAS TRANSACTIONS on computers
Scientific paper
ASP.NET web applications typically employ server controls to provide dynamic web pages, and data-bound server controls to display and maintain database data. Most developers use default properties of ASP.NET server controls when developing web applications, which allows for rapid development of workable applications. However, creating a high-performance, multi-user, and scalable web application requires enhancement of server controls using custom-made code. In this empirical study we evaluate the impact of various technical approaches for paging and sorting functionality in data-driven ASP.NET web applications: automatic data paging and sorting in web server controls on web server; paging and sorting on database server; indexed and non-indexed database columns; clustered vs. non-clustered indices. We observed significant performance improvements when custom paging based on SQL stored procedure and clustered index is used. We have applied our approach for sorting and paging to stored procedures from the SQL Server-based ASP.NET membership provider by Microsoft. Execution time reduces by a factor of 2.7 when our approach is used. With an appropriate use of a clustered index, execution time can be reduced between 3 and 11 times depending on the number of table records.
Stojanovski Toni
Velinov Ivan
Vučkovik Marko
No associations
LandOfFree
Scalability of Data Binding in ASP.NET Web Applications does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with Scalability of Data Binding in ASP.NET Web Applications, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Scalability of Data Binding in ASP.NET Web Applications will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-557139