November 2007 Entries

Creating a Performance Benchmark Framework for Your .NET Codes

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...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Print | posted on Posted On Thursday, November 22, 2007 4:32 PM | Feedback (1)

Performing Long Running Operation with Asynchronous Page in ASP.NET 2.0

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...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Print | posted on Posted On Thursday, November 22, 2007 1:29 PM | Feedback (2)

Performance Benchmark on Database Column and Row Expansion

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...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Print | posted on Posted On Monday, November 19, 2007 4:50 PM | Feedback (0)

Efficient Batch Operation From ASP.NET 2.0 Using SQL Server 2005 XML Data Type

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...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Print | posted on Posted On Monday, November 19, 2007 3:52 PM | Feedback (1)

We have reached 100: ASP.NET Developers, Bangladesh

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...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Print | posted on Posted On Monday, November 19, 2007 3:21 PM | Feedback (0)

Copyright © Mohammad Ashraful Alam