Geeks With Blogs

News Ashraful Alam Joy

Create Your Badge

Ashraful Alam is a Software Architect, who has 8 years of professional experience in Software Development industry. This Bangladeshi national is involved with project management and development of several US based software projects from his country. Already he has managed and developed several software projects, which are being used by several users of different countries, such as USA, Canada, Australia, and Bangladesh. While developing and managing a team, he contains and maintains a set of well defined engineering practices developed by him and other online developer communities.

Due to his willingness to give effort to improve and share better software development practices, Ashraf has been awarded as “Most Valuable Professional” (MVP) in ASP.NET category by Microsoft since year 2007 multiple times, which is a rare honor and prestigious reorganization among the developers around the world.

Check his portfolio to know more about him and his works.


.NETTER Characters... Every part of your life is best, if you can know yourself and thus create your life like an artist!

speed

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 0, read-ahead reads 0.

Expanding Rows

A table having 1 column with nchar(10) data type with 80,017 rows, query executes:

SQL Server Execution Times: CPU time = 63 ms, elapsed time = 253 ms.

Scan count 1, logical reads 301, physical reads 0, read-ahead reads 0.

Posted on Monday, November 19, 2007 4:50 PM | Back to top


Comments on this post: Performance Benchmark on Database Column and Row Expansion

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Ashraf Alam | Powered by: GeeksWithBlogs.net | Join free