想在開發(fā)中使用NHibernate，但擔(dān)心在性能上的問題，對查詢的速度和Ado.Net進行了一下簡單的比較。過程和代碼如下描述，由于了解不深，暫不做結(jié)論，希望大家給點意見。

NHibernate HQL方式 : 830 條記錄， 加載時間(ms) : 3334.7952  綁定IList時間(ms) : 70.1008
Ado.Net DbDataAdapter方式 : 830 條記錄； 加載時間(ms) ： 40.0576  綁定IList時間(ms) ： 80.1152

測試環(huán)境：WinForm方式,數(shù)據(jù)庫也在本機
硬件：CPU --  1.2G AMD duron(tm)          RAM -- 384M  DDR266
軟件：Windows Server 2003, Sql Server 2000,Visual Studio.Net 2005

測試代碼下載http://www.survivalescaperooms.com/Files/liuyuanhuo/NHibernateTest_Performance.rar

測試的代碼是在
子非魚 NHibernate學(xué)習(xí) http://sifang2004.VEVb.com/archive/2005/09/05/230713.aspx
NHibernate 博客園專題之一  http://www.survivalescaperooms.com/Files/sifang2004/NHibernateTest.rar
中下載的示例中作修改的。

測試由兩個工程組成，
一.NHibernateTest工程，僅修改兩個地方
 1.注釋Order.hbm.xml中_Items相關(guān)的<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,訂單數(shù)據(jù)表</returns>
        public DataTable LoadAllByAdoNet()
        {
            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復(fù)制一份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 = "";

            // 測試加載數(shù)據(jù)時間
            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;

            // 測試綁定數(shù)據(jù)時間
            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 = "";

            // 測試加載數(shù)據(jù)時間
            DateTime dtStart = System.DateTime.Now;
            DataTable dtOrders = order.LoadAllByAdoNet();   // 使用Ado.Net DbDataAdapter方式查詢
            DateTime dtEnd = System.DateTime.Now;
            TimeSpan ts = dtEnd - dtStart;
            strOutput += "Ado.Net DbDataAdapter方式 : "
                + dtOrders.Rows.Count + " 條記錄； 加載時間(ms) ： "
                + ts.TotalMilliseconds;

            // 測試綁定數(shù)據(jù)時間
            dtStart = System.DateTime.Now;
            this.dgvOrders.DataSource = dtOrders;
            dtEnd = System.DateTime.Now;
            ts = dtEnd - dtStart;
            strOutput += "  綁定IList時間 ： " + ts.TotalMilliseconds;

            Console.WriteLine( strOutput );
        }
    }
}

運行后界面如下：

在界面兩個按鈕點擊多次后，兩者的查詢時間穩(wěn)定，可以作為比較。下面是輸出：
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

另外在網(wǎng)上找了一下關(guān)于NHibernate性能的討論的有，
http://kevin-y.VEVb.com/archive/2006/02/08/327164.html
http://wljcan.VEVb.com/archive/2005/05/14/155495.aspx
很少，希望能有已經(jīng)做過NHibernate考量的高手提供點路子，非常感謝。