Reader转化为Entity类时系统性能的测试报告

在最常见的用法中，从Reader到Entity或Collection或List时总会用到对象转化。

这里提供一份简陋的性能测试报告(仅代表downmoon或邀月)的观点。

一、在测试之前，首先准备一个表(SQL2005）

Database Name :TestBigData

Table:Product

这里，提供一些傻瓜语句

Code

假定己插入2048条记录

二、创建ConSole Application

主要三个类如下：

最常见的用法：

Code

using System;

using System.Data.SqlClient;

namespace DownmoonTestConsole

{

public class ManualBuilder

{

public Agronet.Product.Framework.Components.Product Build(SqlDataReader reader)

{

Agronet.Product.Framework.Components.Product m_Product = new Agronet.Product.Framework.Components.Product();

if (reader["P_ID"] != DBNull.Value) { m_Product.P_ID = Convert.ToInt64(reader["P_ID"]); }

if (reader["P_Name"] != DBNull.Value) { m_Product.P_Name = Convert.ToString(reader["P_Name"]); }

if (reader["P_E_ID"] != DBNull.Value) { m_Product.P_E_ID = Convert.ToInt32(reader["P_E_ID"]); }

if (reader["CategoryID1"] != DBNull.Value) { m_Product.CategoryID1 = Convert.ToInt32(reader["CategoryID1"]); }

if (reader["CategoryID2"] != DBNull.Value) { m_Product.CategoryID2 = Convert.ToInt32(reader["CategoryID2"]); }

if (reader["CategoryID3"] != DBNull.Value) { m_Product.CategoryID3 = Convert.ToInt32(reader["CategoryID3"]); }

if (reader["CategoryID4"] != DBNull.Value) { m_Product.CategoryID4 = Convert.ToInt32(reader["CategoryID4"]); }

if (reader["CategoryID5"] != DBNull.Value) { m_Product.CategoryID5 = Convert.ToInt32(reader["CategoryID5"]); }

if (reader["CategoryID6"] != DBNull.Value) { m_Product.CategoryID6 = Convert.ToInt32(reader["CategoryID6"]); }

if (reader["P_SysCate"] != DBNull.Value) { m_Product.P_SysCate = Convert.ToString(reader["P_SysCate"]); }

if (reader["P_Key"] != DBNull.Value) { m_Product.P_Key = Convert.ToString(reader["P_Key"]); }

if (reader["P_SellArea"] != DBNull.Value) { m_Product.P_SellArea = Convert.ToString(reader["P_SellArea"]); }

if (reader["P_SingleIntro"] != DBNull.Value) { m_Product.P_SingleIntro = Convert.ToString(reader["P_SingleIntro"]); }

if (reader["P_Intro"] != DBNull.Value) { m_Product.P_Intro = Convert.ToString(reader["P_Intro"]); }

if (reader["P_Order"] != DBNull.Value) { m_Product.P_Order = Convert.ToDouble(reader["P_Order"]); }

if (reader["P_Cate"] != DBNull.Value) { m_Product.P_Cate = Convert.ToString(reader["P_Cate"]); }

if (reader["P_Cate1"] != DBNull.Value) { m_Product.P_Cate1 = Convert.ToInt32(reader["P_Cate1"]); }

if (reader["P_Cate2"] != DBNull.Value) { m_Product.P_Cate2 = Convert.ToInt32(reader["P_Cate2"]); }

if (reader["P_Cate3"] != DBNull.Value) { m_Product.P_Cate3 = Convert.ToInt32(reader["P_Cate3"]); }

if (reader["P_C_Order"] != DBNull.Value) { m_Product.P_C_Order = Convert.ToInt32(reader["P_C_Order"]); }

if (reader["P_TopTime"] != DBNull.Value) { m_Product.P_TopTime = Convert.ToDateTime(reader["P_TopTime"]); }

if (reader["P_BigImage"] != DBNull.Value) { m_Product.P_BigImage = Convert.ToString(reader["P_BigImage"]); }

if (reader["P_SmallImage"] != DBNull.Value) { m_Product.P_SmallImage = Convert.ToString(reader["P_SmallImage"]); }

if (reader["P_BigImage2"] != DBNull.Value) { m_Product.P_BigImage2 = Convert.ToString(reader["P_BigImage2"]); }

if (reader["P_SmallImage2"] != DBNull.Value) { m_Product.P_SmallImage2 = Convert.ToString(reader["P_SmallImage2"]); }

if (reader["P_BigImage3"] != DBNull.Value) { m_Product.P_BigImage3 = Convert.ToString(reader["P_BigImage3"]); }

if (reader["P_SmallImage3"] != DBNull.Value) { m_Product.P_SmallImage3 = Convert.ToString(reader["P_SmallImage3"]); }

if (reader["LoginID"] != DBNull.Value) { m_Product.LoginID = Convert.ToString(reader["LoginID"]); }

if (reader["CurState"] != DBNull.Value) { m_Product.CurState = Convert.ToInt16(reader["CurState"]); }

if (reader["RecState"] != DBNull.Value) { m_Product.RecState = Convert.ToInt16(reader["RecState"]); }

if (reader["P_CheckInfo"] != DBNull.Value) { m_Product.P_CheckInfo = Convert.ToString(reader["P_CheckInfo"]); }

if (reader["P_Max"] != DBNull.Value) { m_Product.P_Max = Convert.ToString(reader["P_Max"]); }

if (reader["P_Min"] != DBNull.Value) { m_Product.P_Min = Convert.ToString(reader["P_Min"]); }

if (reader["P_Unit"] != DBNull.Value) { m_Product.P_Unit = Convert.ToString(reader["P_Unit"]); }

if (reader["P_L_ID"] != DBNull.Value) { m_Product.P_L_ID = Convert.ToInt32(reader["P_L_ID"]); }

if (reader["C_ID"] != DBNull.Value) { m_Product.C_ID = Convert.ToInt32(reader["C_ID"]); }

if (reader["C_I_ID"] != DBNull.Value) { m_Product.C_I_ID = Convert.ToInt32(reader["C_I_ID"]); }

if (reader["P_NewInfo"] != DBNull.Value) { m_Product.P_NewInfo = Convert.ToString(reader["P_NewInfo"]); }

if (reader["P_Price"] != DBNull.Value) { m_Product.P_Price = Convert.ToString(reader["P_Price"]); }

if (reader["P_OtherState"] != DBNull.Value) { m_Product.P_OtherState = Convert.ToInt32(reader["P_OtherState"]); }

if (reader["P_NewKey1"] != DBNull.Value) { m_Product.P_NewKey1 = Convert.ToString(reader["P_NewKey1"]); }

if (reader["P_NewKey2"] != DBNull.Value) { m_Product.P_NewKey2 = Convert.ToString(reader["P_NewKey2"]); }

if (reader["P_NewKey3"] != DBNull.Value) { m_Product.P_NewKey3 = Convert.ToString(reader["P_NewKey3"]); }

if (reader["AddTime"] != DBNull.Value) { m_Product.AddTime = Convert.ToDateTime(reader["AddTime"]); }

if (reader["AddUser"] != DBNull.Value) { m_Product.AddUser = Convert.ToString(reader["AddUser"]); }

if (reader["ModTime"] != DBNull.Value) { m_Product.ModTime = Convert.ToDateTime(reader["ModTime"]); }

if (reader["ModUser"] != DBNull.Value) { m_Product.ModUser = Convert.ToString(reader["ModUser"]); }

if (reader["F1"] != DBNull.Value) { m_Product.F1 = Convert.ToInt32(reader["F1"]); }

if (reader["F2"] != DBNull.Value) { m_Product.F2 = Convert.ToInt32(reader["F2"]); }

if (reader["F3"] != DBNull.Value) { m_Product.F3 = Convert.ToString(reader["F3"]); }

if (reader["F4"] != DBNull.Value) { m_Product.F4 = Convert.ToString(reader["F4"]); }

if (reader["WebSite"] != DBNull.Value) { m_Product.WebSite = Convert.ToString(reader["WebSite"]); }

if (reader["Languages"] != DBNull.Value) { m_Product.Languages = Convert.ToString(reader["Languages"]); }

return m_Product;

}

第二种用法(Reflect)：

Code

第三种用法(DynaMicmethod ,基于IL）

Code

using System;

using System.Data.SqlClient;

using System.Reflection;

using System.Reflection.Emit;

using System.Data;

namespace DownmoonTestConsole

{

public class DynamicBuilder<T>

{

private static readonly MethodInfo getValueMethod = typeof(IDataRecord).GetMethod("get_Item", new Type[] { typeof(int) });

private static readonly MethodInfo isDBNullMethod = typeof(IDataRecord).GetMethod("IsDBNull", new Type[] { typeof(int) });

private delegate T Load(IDataRecord dataRecord);

private Load handler;

private DynamicBuilder() { }

public T Build(IDataRecord dataRecord)

{

return handler(dataRecord);

}

public static DynamicBuilder<T> CreateBuilder(IDataRecord dataRecord)

{

DynamicBuilder<T> dynamicBuilder = new DynamicBuilder<T>();

DynamicMethod method = new DynamicMethod("DynamicCreate", typeof(T), new Type[] { typeof(IDataRecord) }, typeof(T), true);

ILGenerator generator = method.GetILGenerator();

LocalBuilder result = generator.DeclareLocal(typeof(T));

generator.Emit(OpCodes.Newobj, typeof(T).GetConstructor(Type.EmptyTypes));

generator.Emit(OpCodes.Stloc, result);

for (int i = 0; i < dataRecord.FieldCount; i++)

{

PropertyInfo propertyInfo = typeof(T).GetProperty(dataRecord.GetName(i));

Label endIfLabel = generator.DefineLabel();

if (propertyInfo != null && propertyInfo.GetSetMethod() != null)

{

generator.Emit(OpCodes.Ldarg_0);

generator.Emit(OpCodes.Ldc_I4, i);

generator.Emit(OpCodes.Callvirt, isDBNullMethod);

generator.Emit(OpCodes.Brtrue, endIfLabel);

generator.Emit(OpCodes.Ldloc, result);

generator.Emit(OpCodes.Ldarg_0);

generator.Emit(OpCodes.Ldc_I4, i);

generator.Emit(OpCodes.Callvirt, getValueMethod);

generator.Emit(OpCodes.Unbox_Any, dataRecord.GetFieldType(i));

generator.Emit(OpCodes.Callvirt, propertyInfo.GetSetMethod());

generator.MarkLabel(endIfLabel);

}

generator.Emit(OpCodes.Ldloc, result);

generator.Emit(OpCodes.Ret);

dynamicBuilder.handler = (Load)method.CreateDelegate(typeof(Load));

return dynamicBuilder;

}

基于的实体类

Code

using System;

namespace Agronet.Product.Framework.Components

{

Product#region Product

public class Product

{

private long m_P_ID;

/// <summary>

/// 产品ID

/// </summary>

public long P_ID

{

get { return m_P_ID; }

set { m_P_ID = value; }

}

private string m_P_Name;

/// <summary>

/// 产品名称

/// </summary>

public string P_Name

{

get { return m_P_Name; }

set { m_P_Name = value; }

}

private int m_P_E_ID;

/// <summary>

/// 分类扩展属性ID

/// </summary>

public int P_E_ID

{

get { return m_P_E_ID; }

set { m_P_E_ID = value; }

}

private int m_CategoryID1;

/// <summary>

/// 产品产业分类

/// </summary>

public int CategoryID1

{

get { return m_CategoryID1; }

set { m_CategoryID1 = value; }

}

private int m_CategoryID2;

/// <summary>

/// 产品行业分类

/// </summary>

public int CategoryID2

{

get { return m_CategoryID2; }

set { m_CategoryID2 = value; }

}

private int m_CategoryID3;

/// <summary>

/// 第三分类ID

/// </summary>

public int CategoryID3

{

get { return m_CategoryID3; }

set { m_CategoryID3 = value; }

}

private int m_CategoryID4;

/// <summary>

/// 第四分类ID

/// </summary>

public int CategoryID4

{

get { return m_CategoryID4; }

set { m_CategoryID4 = value; }

}

private int m_CategoryID5;

/// <summary>

/// 第五分类ID

/// </summary>

public int CategoryID5

{

get { return m_CategoryID5; }

set { m_CategoryID5 = value; }

}

private int m_CategoryID6;

/// <summary>

/// 第六分类ID

/// </summary>

public int CategoryID6

{

get { return m_CategoryID6; }

set { m_CategoryID6 = value; }

}

private string m_P_SysCate;

/// <summary>

/// 系统分类(旧）

/// </summary>

public string P_SysCate

{

get { return m_P_SysCate; }

set { m_P_SysCate = value; }

}

private string m_P_Key;

/// <summary>

/// 关键字

/// </summary>

public string P_Key

{

get { return m_P_Key; }

set { m_P_Key = value; }

}

private string m_P_SellArea;

/// <summary>

/// 产品销售地区

/// </summary>

public string P_SellArea

{

get { return m_P_SellArea; }

set { m_P_SellArea = value; }

}

private string m_P_SingleIntro;

/// <summary>

/// 简介

/// </summary>

public string P_SingleIntro

{

get { return m_P_SingleIntro; }

set { m_P_SingleIntro = value; }

}

private string m_P_Intro;

/// <summary>

/// 介绍

/// </summary>

public string P_Intro

{

get { return m_P_Intro; }

set { m_P_Intro = value; }

}

private double m_P_Order;

/// <summary>

/// 排序

/// </summary>

public double P_Order

{

get { return m_P_Order; }

set { m_P_Order = value; }

}

private string m_P_Cate;

/// <summary>

/// 分类(旧)

/// </summary>

public string P_Cate

{

get { return m_P_Cate; }

set { m_P_Cate = value; }

}

private int m_P_Cate1;

/// <summary>

/// 产品原分类1

/// </summary>

public int P_Cate1

{

get { return m_P_Cate1; }

set { m_P_Cate1 = value; }

}

private int m_P_Cate2;

/// <summary>

/// 产品原分类2

/// </summary>

public int P_Cate2

{

get { return m_P_Cate2; }

set { m_P_Cate2 = value; }

}

private int m_P_Cate3;

/// <summary>

/// 产品原分类3

/// </summary>

public int P_Cate3

{

get { return m_P_Cate3; }

set { m_P_Cate3 = value; }

}

private int m_P_C_Order;

/// <summary>

/// 企业顺序

/// </summary>

public int P_C_Order

{

get { return m_P_C_Order; }

set { m_P_C_Order = value; }

}

private DateTime m_P_TopTime;

/// <summary>

/// 置顶时间

/// </summary>

public DateTime P_TopTime

{

get { return m_P_TopTime; }

set { m_P_TopTime = value; }

}

private DateTime m_AddTime;

/// <summary>

/// 新增时间

/// </summary>

public DateTime AddTime

{

get { return m_AddTime; }

set { m_AddTime = value; }

}

private string m_AddUser;

/// <summary>

/// 新增用户

/// </summary>

public string AddUser

{

get { return m_AddUser; }

set { m_AddUser = value; }

}

private DateTime m_ModTime;

/// <summary>

/// 修改时间

/// </summary>

public DateTime ModTime

{

get { return m_ModTime; }

set { m_ModTime = value; }

}

private string m_ModUser;

/// <summary>

/// 修改人

/// </summary>

public string ModUser

{

get { return m_ModUser; }

set { m_ModUser = value; }

}

private string m_P_BigImage;

/// <summary>

/// 大图地址

/// </summary>

public string P_BigImage

{

get { return m_P_BigImage; }

set { m_P_BigImage = value; }

}

private string m_P_SmallImage;

/// <summary>

/// 小图地址

/// </summary>

public string P_SmallImage

{

get { return m_P_SmallImage; }

set { m_P_SmallImage = value; }

}

private string m_P_BigImage2;

/// <summary>

/// 大图地址2

/// </summary>

public string P_BigImage2

{

get { return m_P_BigImage2; }

set { m_P_BigImage2 = value; }

}

private string m_P_SmallImage2;

/// <summary>

/// 小图地址2

/// </summary>

public string P_SmallImage2

{

get { return m_P_SmallImage2; }

set { m_P_SmallImage2 = value; }

}

private string m_P_BigImage3;

/// <summary>

/// 大图地址3

/// </summary>

public string P_BigImage3

{

get { return m_P_BigImage3; }

set { m_P_BigImage3 = value; }

}

private string m_P_SmallImage3;

/// <summary>

/// 小图地址3

/// </summary>

public string P_SmallImage3

{

get { return m_P_SmallImage3; }

set { m_P_SmallImage3 = value; }

}

private string m_LoginID;

/// <summary>

/// 登录帐号

/// </summary>

public string LoginID

{

get { return m_LoginID; }

set { m_LoginID = value; }

}

private short m_CurState;

/// <summary>

/// 审核状态

/// </summary>

public short CurState

{

get { return m_CurState; }

set { m_CurState = value; }

}

private short m_RecState;

/// <summary>

/// 推荐状态

/// </summary>

public short RecState

{

get { return m_RecState; }

set { m_RecState = value; }

}

private string m_P_CheckInfo;

/// <summary>

/// 审核信息

/// </summary>

public string P_CheckInfo

{

get { return m_P_CheckInfo; }

set { m_P_CheckInfo = value; }

}

private string m_P_Max;

/// <summary>

/// 单价上限

/// </summary>

public string P_Max

{

get { return m_P_Max; }

set { m_P_Max = value; }

}

private string m_P_Min;

/// <summary>

/// 单价下限

/// </summary>

public string P_Min

{

get { return m_P_Min; }

set { m_P_Min = value; }

}

private string m_P_Unit;

/// <summary>

/// 单价单位

/// </summary>

public string P_Unit

{

get { return m_P_Unit; }

set { m_P_Unit = value; }

}

private int m_P_L_ID;

/// <summary>

/// 商标ID

/// </summary>

public int P_L_ID

{

get { return m_P_L_ID; }

set { m_P_L_ID = value; }

}

private int m_C_ID;

/// <summary>

/// 企业ID

/// </summary>

public int C_ID

{

get { return m_C_ID; }

set { m_C_ID = value; }

}

private int m_C_I_ID;

/// <summary>

/// 联系方式ID

/// </summary>

public int C_I_ID

{

get { return m_C_I_ID; }

set { m_C_I_ID = value; }

}

private string m_P_NewInfo;

/// <summary>

/// 扩展联系方式

/// </summary>

public string P_NewInfo

{

get { return m_P_NewInfo; }

set { m_P_NewInfo = value; }

}

private string m_P_Price;

/// <summary>

/// 价格(旧)

/// </summary>

public string P_Price

{

get { return m_P_Price; }

set { m_P_Price = value; }

}

private int m_P_OtherState;

/// <summary>

/// 其他状态

/// </summary>

public int P_OtherState

{

get { return m_P_OtherState; }

set { m_P_OtherState = value; }

}

private string m_P_NewKey1;

/// <summary>

/// 新关键字一

/// </summary>

public string P_NewKey1

{

get { return m_P_NewKey1; }

set { m_P_NewKey1 = value; }

}

private string m_P_NewKey2;

/// <summary>

/// 新关键字二

/// </summary>

public string P_NewKey2

{

get { return m_P_NewKey2; }

set { m_P_NewKey2 = value; }

}

private string m_P_NewKey3;

/// <summary>

/// 新关键字三

/// </summary>

public string P_NewKey3

{

get { return m_P_NewKey3; }

set { m_P_NewKey3 = value; }

}

private int m_F1;

/// <summary>

/// 扩展1

/// </summary>

public int F1

{

get { return m_F1; }

set { m_F1 = value; }

}

private int m_F2;

/// <summary>

/// 扩展2

/// </summary>

public int F2

{

get { return m_F2; }

set { m_F2 = value; }

}

private string m_F3;

/// <summary>

/// 扩展3

/// </summary>

public string F3

{

get { return m_F3; }

set { m_F3 = value; }

}

private string m_F4;

/// <summary>

/// 扩展4

/// </summary>

public string F4

{

get { return m_F4; }

set { m_F4 = value; }

}

private string m_WebSite;

/// <summary>

/// 网站

/// </summary>

public string WebSite

{

get { return m_WebSite; }

set { m_WebSite = value; }

}

private string m_Languages;

/// <summary>

/// 语言

/// </summary>

public string Languages

{

get { return m_Languages; }

set { m_Languages = value; }

}

#endregion

}

测试主要方法

Code

在网络流量200的负载测试下

结果如图
邀月工作室

邀月工作室

结论　在vs2005环境下，从Reader流转化为List<T>或IList<T>时，Reflect方法效率最低，DynamicMethod次之，但性能与Manual方法相当接近，综合而言， DynamicMethod代码量小，移植性好，性能相对也不错，值得推荐!

最主要的是：当Entity的属性值个数大于Reader的Column个数时，Reflect和DynamicMethod性能更佳，且不会报错！换言之，当你需取表中的某几个字段时，DynamicMwthod的优势是显而易见的！　

posted @ 2008-09-01 22:20 邀月阅读(4327) 评论(27) 编辑收藏举报

刷新页面返回顶部

Reader转化为Entity类时系统性能的测试报告

公告