当前页面位置: » 丰搜网 » 文档中心 » 详细内容
nhibernate与ado.net查询速度的比较
想在开发中使用nhibernate，但担心在性能上的问题，对查询的速度和ado.net进行了一下简单的比较。过程和代码如下描述，由于了解不深，暂不做结论，希望大家给点意见。
nhibernate hql方式 : 830 条记录， 加载时间(ms) : 3334.7952 绑定ilist时间(ms) : 70.1008
ado.net dbdataadapter方式 : 830 条记录； 加载时间(ms) ： 40.0576 绑定ilist时间(ms) ： 80.1152
测试环境：winform方式,数据库也在本机
硬件：cpu -- 1.2g amd duron(tm) ram -- 384m ddr266
软件：windows server 2003, sql server 2000,visual studio.net 2005
测试代码下载http://www.cnblogs.com/files/liuyuanhuo/nhibernatetest_performance.rar
测试的代码是在
子非鱼 nhibernate学习 http://sifang2004.cnblogs.com/archive/2005/09/05/230713.aspx
nhibernate 博客园专题之一 http://www.cnblogs.com/files/sifang2004/nhibernatetest.rar
中下载的示例中作修改的。
测试由两个工程组成，
一.nhibernatetest工程，仅修改两个地方
1.注释order.hbm.xml中_items相关的<bag元素
2.在order.cs增加下面两个方法
/**//// <summary>
/// 使用nhibernate hql方式查询
/// </summary>
/// <returns>ilist,订单对象集合</returns>
public ilist loadallbynhibernate()
{
ilist orders = objectloader.find( " from order ", null);
return orders;
}
/**//// <summary>
/// 使用ado.net dbdataadapter方式查询
/// </summary>
/// <returns>datatable,订单数据表</returns>
public datatable loadallbyad.net()
{
datatable dtorders = new datatable();
dbconnection dbconnection = new sqlconnection();
dbconnection.connectionstring =
@"server=andy\andy;initial catalog=northwind;user id =sa;password=sa";
dbcommand dbcommand = new sqlcommand();
dbcommand.connection = dbconnection;
dbcommand.commandtype = commandtype.text;
dbcommand.commandtext = "select * from orders";
dbdataadapter dataadapter = new sqldataadapter();
dataadapter.selectcommand = dbcommand;
dataadapter.fill( dtorders );
return dtorders;
}
二.添加一个nhibernatetestui工程，引用nhibernatetest，从nhibernatetest复制一份app.config到nhibernatetestui，修改连接串，然后添加一个窗体类，加了两个按钮一个datagridview, 两个按钮分别测试ado.net dbdataadapter方式和nhibernate hql方式的加载时间，测试代码如下:
using system;
using system.collections;
using system.componentmodel;
using system.data;
using system.drawing;
using system.text;
using system.windows.forms;
namespace nhibernatetestui
{
public partial class orderfrm : form
{
public orderfrm()
{
initializecomponent();
}
nhibernatetest.order order = new nhibernatetest.order();
/**//// <summary>
/// 使用nhibernate hql方式查询
/// </summary>
private void btnnhload_click( object sender, eventargs e )
{
string stroutput = "";
// 测试加载数据时间
datetime dtstart = system.datetime.now;
ilist orders = order.loadallbynhibernate(); // 使用nhibernate hql方式查询
datetime dtend = system.datetime.now;
timespan ts = dtend - dtstart;
stroutput += "nhibernate hql方式 : "
+ orders.count + " 条记录， 加载时间(ms) : "
+ ts.totalmilliseconds;
// 测试绑定数据时间
dtstart = system.datetime.now;
this.dgvorders.datasource = orders;
dtend = system.datetime.now;
ts = dtend - dtstart;
stroutput += " 绑定ilist时间 : " + ts.totalmilliseconds;
console.writeline( stroutput );
}
/**//// <summary>
/// 使用ado.net dbdataadapter方式查询
/// </summary>
private void btnadoload_click( object sender, eventargs e )
{
string stroutput = "";
// 测试加载数据时间
datetime dtstart = system.datetime.now;
datatable dtorders = order.loadallbyad.net(); // 使用ado.net dbdataadapter方式查询
datetime dtend = system.datetime.now;
timespan ts = dtend - dtstart;
stroutput += "ado.net dbdataadapter方式 : "
+ dtorders.rows.count + " 条记录； 加载时间(ms) ： "
+ ts.totalmilliseconds;
// 测试绑定数据时间
dtstart = system.datetime.now;
this.dgvorders.datasource = dtorders;
dtend = system.datetime.now;
ts = dtend - dtstart;
stroutput += " 绑定ilist时间 ： " + ts.totalmilliseconds;
console.writeline( stroutput );
}
}
}
运行后界面如下：
在界面两个按钮点击多次后，两者的查询时间稳定，可以作为比较。下面是输出：
nhibernate :select order0_.orderid as orderid, order0_.shippeddate as shippedd4_, order0_.shippostalcode as shippos10_, order0_.requireddate as required3_, order0_.shipcountry as shipcou11_, order0_.shipvia as shipvia, order0_.orderdate as orderdate, order0_.shipaddress as shipaddr7_, order0_.shipregion as shipregion, order0_.shipname as shipname, order0_.shipcity as shipcity, order0_.customerid as customerid, order0_.freight as freight, order0_.employeeid as employeeid from orders order0_
nhibernate hql方式 : 830 条记录， 加载时间(ms) : 3334.7952 绑定ilist时间 : 70.1008
nhibernate :select order0_.orderid as orderid, order0_.shippeddate as shippedd4_, order0_.shippostalcode as shippos10_, order0_.requireddate as required3_, order0_.shipcountry as shipcou11_, order0_.shipvia as shipvia, order0_.orderdate as orderdate, order0_.shipaddress as shipaddr7_, order0_.shipregion as shipregion, order0_.shipname as shipname, order0_.shipcity as shipcity, order0_.customerid as customerid, order0_.freight as freight, order0_.employeeid as employeeid from orders order0_
nhibernate hql方式 : 830 条记录， 加载时间(ms) : 3304.752 绑定ilist时间 : 70.1008
nhibernate :select order0_.orderid as orderid, order0_.shippeddate as shippedd4_, order0_.shippostalcode as shippos10_, order0_.requireddate as required3_, order0_.shipcountry as shipcou11_, order0_.shipvia as shipvia, order0_.orderdate as orderdate, order0_.shipaddress as shipaddr7_, order0_.shipregion as shipregion, order0_.shipname as shipname, order0_.shipcity as shipcity, order0_.customerid as customerid, order0_.freight as freight, order0_.employeeid as employeeid from orders order0_
nhibernate hql方式 : 830 条记录， 加载时间(ms) : 3354.824 绑定ilist时间 : 80.1152
ado.net dbdataadapter方式 : 830 条记录； 加载时间(ms) ： 40.0576 绑定ilist时间 ： 80.1152
ado.net dbdataadapter方式 : 830 条记录； 加载时间(ms) ： 40.0576 绑定ilist时间 ： 90.1296
ado.net dbdataadapter方式 : 830 条记录； 加载时间(ms) ： 30.0432 绑定ilist时间 ： 90.1296
nhibernate :select order0_.orderid as orderid, order0_.shippeddate as shippedd4_, order0_.shippostalcode as shippos10_, order0_.requireddate as required3_, order0_.shipcountry as shipcou11_, order0_.shipvia as shipvia, order0_.orderdate as orderdate, order0_.shipaddress as shipaddr7_, order0_.shipregion as shipregion, order0_.shipname as shipname, order0_.shipcity as shipcity, order0_.customerid as customerid, order0_.freight as freight, order0_.employeeid as employeeid from orders order0_
nhibernate hql方式 : 830 条记录， 加载时间(ms) : 3334.7952 绑定ilist时间 : 70.1008
ado.net dbdataadapter方式 : 830 条记录； 加载时间(ms) ： 50.072 绑定ilist时间 ： 90.1296
另外在网上找了一下关于nhibernate性能的讨论的有，
http://kevin-y.cnblogs.com/archive/2006/02/08/327164.html
http://wljcan.cnblogs.com/archive/2005/05/14/155495.aspx
很少，希望能有已经做过nhibernate考量的高手提供点路子，非常感谢。
