杭州网站建设优化推广,包包网站建设,小企业网站建设多少钱,网页传奇游戏下载Why你应该总能听到某ORM性能比Dapper高你应该有如下疑问#xff1a;基准测试是否权威基准测试的方式是否合理基准测试的标准是否能够统一统一基准测试标准/规范如何进行姿势正确的性能测试相信大家对 Dapper 的性能#xff0c;以及基准测试的权威性是没有疑问的#xff08;否… Why你应该总能听到某ORM性能比Dapper高你应该有如下疑问基准测试是否权威基准测试的方式是否合理基准测试的标准是否能够统一统一基准测试标准/规范如何进行姿势正确的性能测试相信大家对 Dapper 的性能以及基准测试的权威性是没有疑问的否则不会有那么多ORM在做性能测试的时候直接选型Dapper,那么我们就使用 Dapper 性能基准测试 来作为我们的基准测试模板并加入一些没有纳入基准测试的 ORM 。这样从合理性/可信度就大体有了一个标准和保障。接下来 fork Dapper GitHub 仓库并添加了 SmartSql/IBatis.Net/FreeSql/SqlSugar/Chloe源代码地址https://github.com/Ahoo-Wang/Dapper,如对测试结果测试方法有疑问请给我提交issue。如何自己进行以上基准测试强烈建议读者按照以下步骤自己运行基准测试。Git-Clone https://github.com/Ahoo-Wang/Dappercd Dapper/Dapper.Tests.Performancedotnet publish -c release运行 Dapper.Tests.Performance.exe提示输入请输入 * 运行所有基准测试等待测试结果目录BenchmarkDotNet.Artifacts 下会有一个日志文件和 results 文件夹 (测试结果文件存放在此目录)基准测试结果重要提示FreeSql/SqlSugar 官方nuget包为非Release版本所以测试结果会有影响仅供参考。BelgradeExecuteReaderPost78.74 us12.25000.6250-10.63 KBLINQ to DBFirst (Compiled)Post97.61 us20.5000--2.67 KBLINQ to DBQueryTPost103.05 us31.37500.1250-6.91 KBHand CodedSqlCommandPost107.37 us42.00001.00000.500012.29 KBDapperQueryFirstOrDefaultdynamicdynamic110.83 us52.87500.1250-13.57 KBDapperQueryFirstOrDefaultTPost111.65 us52.25001.00000.375013.53 KBHand CodedDataTabledynamic114.78 us62.00000.5000-12.51 KBPetaPocoFetchT (Fast)Post114.95 us62.25000.87500.250013.71 KBDapperQuerydynamic (buffered)dynamic115.54 us62.25001.00000.250013.93 KBPetaPocoFetchTPost119.76 us72.50001.00000.250014.66 KBDapperQueryT (buffered)Post122.10 us82.25000.87500.375013.86 KBSusanooExecutdynamic (Static)dynamic122.68 us82.50000.75000.250015.03 KBMassiveQuery (dynamic)dynamic122.82 us82.37500.87500.250014.25 KBServiceStackSingleByIdTPost123.93 us83.00000.75000.250017.59 KBLINQ to DBFirstPost124.53 us81.12500.1250-5.53 KBSmartSqlQuerySingleSqlParameterCollectionPost125.26 us82.50000.75000.250015.48 KBSmartSqlQuerySinglePost126.79 us92.50000.75000.250015.59 KBLINQ to SQLFirst (Compiled)Post127.17 us92.0000--9.87 KBSmartSqlGetByIdPost127.24 us92.75000.75000.250015.89 KBSmartSqlQuerySingleStrongRequestPost127.70 us92.50000.75000.250015.51 KBSmartSqlQuerySingleFromXmlPost128.27 us92.75000.75000.250016.23 KBSusanooExecuteT (Static)Post128.92 us92.50000.75000.250015.05 KBSmartSqlQuerySingleStrongRequestdynamicdynamic129.88 us92.75001.00000.500016.54 KBSmartSqlQuerySingleSqlParameterCollectiondynamicdynamic130.96 us92.50000.75000.250016.51 KBDapperContrib GetTPost132.10 us92.25001.00000.250014.51 KBDevExpress.XPOFindObjectTPost137.14 us106.50000.2500-29.97 KBSusanooExecutedynamic (Cache)dynamic140.24 us113.25001.00000.500020.48 KBSusanooExecuteT (Cache)Post141.23 us113.25000.75000.250020.96 KBEF 6SqlQueryPost154.68 us124.75000.7500-27.96 KBDevExpress.XPOGetObjectByKeyTPost160.87 us135.25001.2500-32.35 KBIBatisQueryForObjectPost163.87 us142.75000.75000.250016.59 KBDapperQueryT (unbuffered)Post166.28 us152.25000.75000.250013.89 KBDapperQuerydynamic (unbuffered)dynamic171.82 us162.25000.75000.250013.93 KBDevExpress.XPOQueryTPost172.38 us167.50000.2500-35.02 KBFreeSqlFromSqlFirstDynamicdynamic180.44 us173.25000.75000.250019.38 KBEF CoreFirst (Compiled)Post188.02 us183.5000--16.14 KBFreeSqlFromSqlFirstPost196.92 us193.25000.75000.250019.17 KBNHibernateGetTPost201.46 us205.75000.7500-32.62 KBNHibernateHQLPost207.57 us215.50000.7500-35.11 KBChloeFirstPost209.26 us215.00000.75000.250029.85 KBEF CoreSqlQueryPost234.51 us224.0000--20.64 KBEF CoreFirstPost238.67 us234.2500--20.33 KBEF 6FirstPost243.86 us2410.5000--48.44 KBLINQ to SQLExecuteQueryPost250.54 us257.00001.00000.500042.48 KBEF CoreFirst (No Tracking)Post250.59 us253.75000.75000.250021.44 KBNHibernateCriteriaPost256.87 us2611.00001.0000-65.64 KBEF 6First (No Tracking)Post314.69 us279.00001.0000-55.27 KBNHibernateSQLPost336.02 us2819.00001.0000-101.4 KBFreeSqlFirstPost429.83 us295.00001.00000.500031.56 KBSqlSugarFirstPost583.49 us3010.00001.0000-62.5 KBLINQ to SQLFirstPost761.03 us313.00001.0000-14.7 KBNHibernateLINQPost778.43 us3210.00002.0000-64.03 KB原文地址https://www.cnblogs.com/Ahoo-Wang/p/dotnet-orm-performance-test.html.NET社区新闻深度好文欢迎访问公众号文章汇总 http://www.csharpkit.com
