Performance is a one of the basic requirements in the most of the current trend of web applications. While designing software architecture, there are several technologies kept available for the designers. Among these available options, some of techniques may includes multiple solutions, combining of those can create a case, where the basic performance output can't be determined based on the common sense and/or in depth knowledge on the corresponding topics. In short, based upon different options ......
Technorati Tags: asp.net,async,web service,performance,database There are few cases in current web applications, where it involves long running operations. For instance, a system admin uploads 1 gig of data in the system, which will be processed by the system for 30-40 minutes to be splitted and putted properly in the database system, as well as notifying other system user regarding the availability if data. In the traditional approach of web application, the user has to wait for the whole time until ......
What performs better – Expanding DB column or expanding db row? My benchmark test shows expanding DB column performs better, on the following machine configuration: Processor: Intel® Pentium® 4; 2.66 GHz; Memory: 960 RAM. Operating System: Windows XP, Version 2002, Service Pack 2. Expanding Columns A table having 4 columns with nchar(10) data type with 20,112 rows, query executes: SQL Server Execution Times: CPU time = 47 ms, elapsed time = 125 ms. Scan count 1, logical reads 232, physical reads ......
One of the good practice while developing high performance web application is to reduce the database roundtrip as much as possible. In the current trend of web applications, its a very common to enable users to delete multiple items in a list user interface at a time. To perform this type of batch delete operation, one common mistake that happens by beginner developers are to calling the data access method repetitively for each item with in a loop as below: For Each row As GridViewRow In gvEmployees.Rows ......
We have reached 100 members recently in our user group ASP.NET Developers, Bangladesh. Its a good news really. Having our own user group help us to move forward with respect to the current technology trend in faster and professional manner. Hope we will grow faster. Cheers to all group members ......