.NET     Console.WriteLine( "All Things .NET" );
.NET Nerd Blog Home
7.24.2002

 

Database Timings

SqlDataConnection/Adapter
select * from tps_stations where location is not null == (139 rows)
loop over these operations 100 times

SqlDataReader
TypedDataSet
DataSet

First column - retrieve DataReader and DataSet data by column number. Retrieve as object (no cast).
Second column - retrieve DataReader and DataSet data by column number. Cast to string.
Third column - retrieve DataReader and DataSet data by column name. Cast to string.
Typed DataSet does the same thing in all 3 columns - retrieve string member by property accessor.

Results are in "operations per second"

Object = r[ColNum]

String = r[ColNum].ToString

String = r[ColName].ToString

DataReader

15

15

14

Typed DataSet

26

26

26

DataSet

35

--

--




posted by dan @ 5:12 PM    |    0 comments    |    PermaLink URL    |   
Comments: Post a Comment

Powered by Blogger