• 热门专题

微型 ORM 的第二篇 DapperLambda性能测试[Dapper比较篇]

作者:林锋  发布日期:2016-01-11 20:45:11
Tag标签:性能  第二  
  • 由于这周比较忙,所以本来想做的性能测试,一直没时间,想想还是今天给补上吧

    由于很多人都担心性能问题,封装之后跟Dapper的性能差距是多少,今天我给出我的测试方法,仅供参考.

    创建IDbConnection;(DapperLambda 已经把IDbConnection封装在DbContext,所以创建的是DbContext)
     1   public class DBHelper
     2     {
     3         private static string localStr = 'server=(local);User ID=sa;Password=password01!;Database=LocalDB;Persist Security Info=True;Pooling=true;Max Pool Size=700';
     4         public static DbContext GetContext()
     5         {
     6             return new DbContext().ConnectionString(localStr);
     7         }
     8         public static System.Data.IDbConnection GetDapperConnection()
     9         {
    10             return new System.Data.SqlClient.SqlConnection(localStr);
    11         }
    12     }

       2.主要针对几个增删改查,几个做比较,但是用到Dapper比较简单,都是执行SQL+参数。。

        1).查询语句的比较

           public static long DapperSelect()
            {
                Stopwatch timer = new Stopwatch();
                timer.Start();
                Random r = new Random();
                using (var conn = DBHelper.GetDapperConnection())
                {
                    var item = conn.Query<Models.MobileForTest>('SELECT * FROM MobileForTest mft WHERE mft.ID=@ID', new { ID = r.Next(1, 3014) });
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }
           public static long DapperLambdaSQLSelect()
            {
    
                Stopwatch timer = new Stopwatch();
                timer.Start();
                Random r = new Random();
                using (var context = DBHelper.GetContext())
                {
                    var item = context.Sql('SELECT * FROM MobileForTest mft WHERE mft.ID=@ID', new { ID = r.Next(1, 3014) }).QueryMany<MobileForTest>();
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }
            public static long DapperLambdaSelectByID()
            {
    
                Stopwatch timer = new Stopwatch();
                timer.Start();
                Random r = new Random();
                using (var context = DBHelper.GetContext())
                {
                    var item = context.Select<MobileForTest>(r.Next(1, 3014));
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }
            public static long DapperLambdaSelectByLambda()
            {
    
                Stopwatch timer = new Stopwatch();
                timer.Start();
                Random r = new Random();
                using (var context = DBHelper.GetContext())
                {
                    var item = context.Select<MobileForTest>(p => p.ID == r.Next(1, 3014)).QueryMany();
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }

    原本计划是起四个线程,在各自线程里调用相应的方法500次,取总耗时时间,发现线程启动的顺序,对测试的结果有明显的影响。因此改成同步的调用每个方法500次,取平均时长。测试结果如下如。

    跟预期差不多是一致。

    2.单条数据插入的

            public static long DapperSQLInsert()
            {
                Stopwatch timer = new Stopwatch();
                timer.Start();
                using (var conn = DBHelper.GetDapperConnection())
                {
                    conn.Execute(@'INSERT INTO [dbo].[MobileForTest]
                                   ([MobileHolder]
                                   ,[MobilePhone]
                                   ,[Status])
                             VALUES
                                   (@MobileHolder
                                   ,@MobilePhone
                                   ,@Status)', new { MobileHolder = 'InsterWithTran', MobilePhone = '18922223333', Status = 0 });
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }
            public static long DapperLambdaSQLInsert()
            {
                Stopwatch timer = new Stopwatch();
                timer.Start();
                using (var context = DBHelper.GetContext())
                {
                    context.Sql(@'INSERT INTO [dbo].[MobileForTest]
                                   ([MobileHolder]
                                   ,[MobilePhone]
                                   ,[Status])
                             VALUES
                                   (@MobileHolder
                                   ,@MobilePhone
                                   ,@Status)').Parameter('MobileHolder', 'DapperLambdaSQLInsert')
                                                   .Parameter('MobilePhone', '18912345678')
                                                   .Parameter('Status', 0).Execute();
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }
            public static long DapperLambdaInsert()
            {
                List<MobileForTest> ls = new List<MobileForTest>();
                Stopwatch timer = new Stopwatch();
                timer.Start();
                using (var context = DBHelper.GetContext())
                {
                    context.Insert<MobileForTest>(new MobileForTest { MobileHolder = 'DapperLambdaInsert', MobilePhone = '18911112222', Status = 0 }).Execute();
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }

    循环500次执行,取平均耗时。

    3.更新方法测试

            public static long DapperSQLUpdate()
            {
                Stopwatch timer = new Stopwatch();
                timer.Start();
                Random r = new Random();
                using (var conn = DBHelper.GetDapperConnection())
                {
                    conn.Execute('UPDATE MobileForTest SET MobileHolder = @MobileHolder WHERE ID=@ID', new { MobileHolder = 'DapperSQLUpdate', ID = r.Next(1, 10000) });
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }
            public static long DapperLambdaSQLUpdate()
            {
                Stopwatch timer = new Stopwatch();
                timer.Start();
                Random r = new Random();
                using (var context = DBHelper.GetContext())
                {
                    context.Sql('UPDATE MobileForTest SET MobileHolder = @MobileHolder WHERE ID=@ID', new { MobileHolder = 'DapperLambdaSQLUpdate', ID = r.Next(1, 10000) }).Execute();
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }
            public static long DapperLambdaUpdate()
            {
                Stopwatch timer = new Stopwatch();
                timer.Start();
                Random r = new Random();
                using (var context = DBHelper.GetContext())
                {
                    context.Update<MobileForTest>().Set(new { MobileHolder = 'DapperLambdaUpdate' }).Where(p => p.ID == r.Next(1, 10000)).Execute();
                }
                timer.Stop();
                return timer.ElapsedMilliseconds;
            }

    总体来说,测试的结果还在预期范围之类,在使用方便和些许的性能中各位抉择。如果有时间的话,考虑换掉Dapper,再重新比较一下。坚持。。。。

延伸阅读:

About IT165 - 广告服务 - 隐私声明 - 版权申明 - 免责条款 - 网站地图 - 网友投稿 - 联系方式
本站内容来自于互联网,仅供用于网络技术学习,学习中请遵循相关法律法规