Performance Benchmark on Database Column and Row Expansion

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.

Print | posted on Monday, November 19, 2007 4:50 PM

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Comment:
Verification: