王朝网络
分享
 
 
 

一次Dapper高并发测试报告记录. 结果....

王朝学院·作者佚名  2016-05-20  
宽屏版  字体: |||超大  

一次Dapper高并发测试报告记录. 结果....一直听说dapper的数据处理能力很强. 我也一直很喜欢. 不过最近的一次压力测试却出乎我的意料....好久没写东西,感觉自己都不知道怎么表达自己的意思了. 另外 这次的测试也是自己才开始的 . 也不知道测试思路和方式是否正确. 各位有什么就来吐槽吐槽吧.

测试代码下载

http://pan.baidu.com/s/1dDzuEi9

2种操作db方式.

1 纯MySQL操作db

2 dapper方式操作db

测试方式1一个用户 运行代码n次数,测试代码执行消耗.在这个模式比较下. dapper 的 CURD操作和纯粹的手写sql效率差别基本不大. 下图是几个操作的对比.

ipv16o/lNSPXVW79t6f5/k+z6OoAADAM4qK/V9eGtp/7OJbxy7u7x7Yf2zgpxtfz/ZGAQBwlVKyvQEAACBGD8zarfHYRQIzAADZQmAGAMBDtMDceOxi47GLjV0XG7sIzAAAZA2BGQAAD4kF5q6Lb2qBeQOBGQCA7CAwAwDgIZHA3HXxTe3WefGnG/Zke6MAALhKEZgBAPAQLTBraXlf18V9nReX/SuBGQCA7CAwAwDgIXpg1tLyvs6LTxKYAQDIEgIzgGS01tXmKaK82rrWbG8U8E0QC8ydF/d1XnyDwAwAQPYQmD1osGnnan/ZokAoPPyvNVA9Z+rocROm3z334UeWb9vVeD4dT9pQUxENUWMbOnrT8ZSWBp6aVzrt7vtfeqUxcD4o/mH7svuvv2n6kuUr32lu7QsODtsGxCF8DoqiKBU1DcP0Qh/uWOETXmjGQxuHe9c5c/zgLfkjxHc3Iv/Wlt7+NL5Ed12t+Py1dd1pfHJVHQx8cuy1Xzy/eMHcyeNGf796d1qfXFXl7U/1hyDuSw47UtPGqpy8UYWFhUU3TX/oiXVnHZ+zt6NhbPQ5/eW1qWyeo88Wllw/obBo7oIfLK95/vU3fzNgc7/d1f/P9TdNf7Lm+ebWk3F/tOFQ36ryGbMrVwdS+4GLX5NxHwu3H9zxnVtmtyayV9eW+41fU7i1YYO/bHGiB3MtMOtpmcAMAEAWxQnM4hWVaL6L60vpIl6/MEvvZa+qhgMn2tYuXzL9pqLR+SP1lxmZP7qwsPgHjyx/7Z3fBR0vVgaDZxtfeekHc+4qLLwuJ/rwUQXXTb977srnd/UYk5hZekNRoLNp9tTx2lPduWidcGXZ7VeSZnuxfu7kgULhfoW3LT2XytZH2QVmu93JgcPnOXDuw5tz9V3M98PVb0T/8ul9E67Rn6FqY1NCGy/lNBPf6HETiqffVbV85TvN7c6X6pkKzOeW3iZ+jdfu/uD08LxQRH9v6+0FeYpJ/rjvJpQunA1rYP70/e3XCE8+Iv+eU2l8dlVVUw7M4VDfC1XzZpTXah+oVWAO71mxyJgYB6rn3KjfbVp5rXNKswnMvRUlif5Mnd7jwLmWG4U72W+V4Wc7aUbVF07b3l9bfrt2z5y88S80tIZNPzdL5t+gZWDuO92+ZFapdnC5df6z7vdpY2Detb16oXZOuT36PbpEYEaiAm17J+aK11y+B2v2ZqDRHQCuBkkG5msm3PdpnGceWDHvZquHpjMwnznePPeWSVax3MDuUjsc6ttRsyQ/1+kJfLkj51auPWMfudMaisJ7ax4UtkascR2WwLy7er74Xlfs+DCFjY/JTGDuQQsVPqtYSjxzVHyVsQ1HzyS08fECs8HI/EnL1u/us9k9MhOYT3+w+1rhVdLV6mHnzPGmaVZpWTNmypwjacrMw9zDbIhnijJi4/4TaX3+lALziff/rXRcvqIoiuKrXLNPtQrMgbY92n6ekzf+ubrDqqqGQ13ThKNZ9cstzq+SmcBs/J36auu6LDfm1IHNYsXC0vUH7Dd88NX/+QPjUdtXOmvJ6ifuj7uJFTUNwrF0bENHr2Vgbtn9rLAxvuqXDzt/kjoxMC9csWZm7JeSWHrRA7OWlhuOEpivJBk+Jquq2t/bdb/8sx27py2QxpeQTt/pPp2FzwY+fqd+W9XiBcWF15XOW2FXh5I0aftTPKGIxw2H8pxTBzaPzB05obCwsLB4weLlxy985fys+uFjbEnFsNXmhVd+/6+uKyy8a86CquUrd9nXFX6445mx426sXL7yneY2524nVVVVdfC1FYtunbWk/XRfKhsnfk3SPhbobJp7y1/vTWSvFs+b2tfU01JfNnVmGlv2cfVIMjAryjXb33eKzFKvgiBtgbnr0LaJjlnX+ch45njTbZFL0vjyx93WdNw6d6U7FJ2pLJ2oP1tewe3RH3b6A3M4dGKGUFU7In/GiTQVgWckMBtaZK6dPF/vVBW/EfHfXUooMGvsdo+MBOaB2vKyRDfYzN22hdsP/npyXo74wImlf1M+s0T8l7yCkvqWntTfWGNtpfCsvnUNaQ6025fdJ2522uvYUwnMYh++L3fi3raAFJiNnfyRK2Nj5pzU9KljH22mAvPmpffEvsXcaV3WB5nwxodmCHe7+cNzThfMg8FA9fzbpKN/bm5u3E10GZhVtb96zlRhe6YedneBJZVkGzv9EhjkrwVmPS27Ccxxj66jCq4rumn6YhdVV0iNYWdOY0u07euFAg8Klw26nLzJDenLzMMamE1XjPEPX4lKOTAP1q9/9C+jwyssA3PL7lW3GxOjeJYZW1IRr/HeOjCLR5WE2LxHQ2Ox/VYZ6pXiFWHFOnt8ufmPRq8fdHcpZW5rsAzMg8HA6srZOZENXuh+hIsxMK9qevlprYdsYumDGRnziG+UpAOzcs/SzQ4PbHm52u4HkpbA3N97eKq7tKxYHTUCbW+W2PeSWcormJaZUHTm6D6xIcCmIPCz8ptG6/eprG1M4oUObqxy+wnGIX+nbgKzQwOqm+Gaxnps8W5nxMt9N2MHJEkEZsXm0iQDgdnYnZ68uNsmnrF0k8seCoTC4VDgobLJ4r/7cvOrtxxIcey48dNL/2B4qSrbPsslKcWS7PaGddEjVM73f/br14w/itdX/TD6XcS6LsVo6qZTy0Vgjn+4Fi7mLN+j4eLMrh5b+jnf7Kp/Kdza8ML4SPNNzsLq7buiH5H52KJvpOvArJ47ebAo/nHY4dOI/KYOv1wdvY4c8+L+Iy6eQ1VVtajY/8WloTc6g3pg/knKgVmUkze6vOq5FId/w5K0M6exJdpSf2/XAqu0rMkrKHkzTZl5mHuYDfFMiVNjkoxUAvP5U4elsXLmwNzf23Jr/ghFUXy5+f9U+28Dqipdjdy3bHu818lEYJauGey+xy8+bZok3M25Qfnwrmel6+nxU2dvfe7HcbfQX14rnnFq67otA7NeTqWZt2y7y1+UMTD/tGpGkf6/iQ6TARILzKWlpfp/OzY4fVE1Q/+tjb5JiHbpCsy/rPovxt+dr3RWZVPrsegMT4OBT47ten6F/4bRiumoMXCu/U5TWh4/dXZ9dIKowWBfa3O9fnzUWbZsDUMoCm9fNk94yrwNjXIRo7E5dsTmA6cSfo3QRzMTbDKwl4XAbGyRKTxwMpIOpFo49/SdRArMxu2M7FdTrWoTrp08r8e4ewx/YDb0g6XCsc1lsGnn6vF5Ulhwps17Sh+qEA4FHjP2MyuKUjLz4dYe52mnnCQdmJMoZHAtsqsPz0tI73Ggtvz20lmVzZ0B1bIku7Np9tTC7y5aGz3rn7rHOA2bJXEnHL7A7LLVSf9xHVi/1M39zb+gvtOt//2WqbW7PxDHMKclMKvyHpi3rqE93odhEZi14dYONUqWIoH5aLDhaLDh6MX6o8H0BmZNTt7k7YesK+SRNDdj6eNyOQlfoPOAVCiXVzDt4UX3GoYy547Z0NCaemQ/0bBOfNrkmukdSL0saa9jTyUwG/vw82rrWqXAbLzDiGd3t6hy5nRznZaJwNy0sUq4i+2YNeMxOc7EKOFQ36+j8zXo3JT8uAzMpqvia7e/76qKTSrJNlZmMcgfiUksMC9eulS4IrMd9SdOJTWu9G9mGQr80hKYpfGHytQ51TZtRYNNO1dtMRRzhjcvnWn8zfr+bsVrVi3t/duWLZD6YM0tW8MRivQ0m5M3fvXOJvO2GWsvb2xxLF+0lJaTuvSdOl6x+bvTWZJtmOZK6I+SauES4C4w619Q346ah83tDdLWDndgbqurjZ+QEnz7RoPNezeV3TDadPechdXbvwwFj7c2r1xeOaVg7Mb9J8KhvtpF3zXVLOTMrnymPanYfBUH5kSLov3dqnpi/0Y3O0NFTYPzxtfWvZfxwHx6/mRXzVzOvyBjYNY/Q393soE5HOqZF9mwnJkPLGs//UEK42KsX8KOFpgbOrTAHKw/2j8cgVlRFF9u/lpWg0ufgXNtZS7areKKG5gtZ2CJTrvYv1Y+FOcsrP613VwbLg3zpBLmquyE5x9xlmJJtlD657t17vJmY2Buea1W/y70rksxmrorNIgbmOOfB8XzptV7NPTk29djG47JLoe29bTU61Nv3Db/6eZXV+mfkF2fiuvALPfxuCzMthjD/P726BvLe2zjmwRmuJdYYH6opkY8otkVaYhNU/cs/Zkx3KYlMMsDet1HEWleaCVOYcY5sYRDsRpcN0yh6PDLT881rpiSXKmw5QcuVRumLNOBWepGXvlqp/bvUi1cQhIKzKqqmmZoUxTTSXFYA7OpUGJEbV2b+4c7Xz30nT25teaxScK087qcvMm/Ptje07z9/xA+6uihYLB+/aNWs+jl+O++f+vepoSW+Nqzolz8HgjMjlvltqnIg4HZZj0F64132JK0B2ZVVdvqav9s6uymTq2oNZWJJGxfwlIsMHcE6zv6kwrM4ncXPhv4uPGVl2aayqaUREZoIx6pHyx5ZYvWObxK+8EdpaYqp4mlC7pi32P/i0vnSD+rMVPuPdjek3RCSCEwp+GHY0M/5gzLS5hLTsZPnb3v8LGwVUm2NrX+n5c9FA1yYqGlLWPLyHAFZtcnrMhBw2Xzq7lZZzDY8+issr+vqTOOYU5DYFblHoLIdJjuP43o1ob31jw4guIaJC6xwFxRs108BNi0mYm9fyM27q83HsgivxxztrEZbirNtq1NsiofHN1PA2CcFzr+tYK5xFdapihja+2mLzBLrQAJTEUTJV3QZzgwy9Nc6WcFl4WdlhIPzKqq9j87/1bj0xjKriz3jXCob9+WldNvul6rXxqZP3r63eXaOTgRA+sW3Sk+eaIFbA6B+d2XnpDLryN8pbMe7YmEXkMBsDgAWFwazWTE/6o/OpzXT0nuZgk9v/nTS5PkA3Ob66aiBANzQpILzGfcv5xYobe3ZvF/Xbqhz6p9Ko2B2SizgXlgqKEjWK8H5udTCcy6waadq8aYdpWy8tq0T0p8FUrXjBKK7YVE+NjhfVYrg/hum//0mdClnq7Wl2qenDZl/D+tP6Cqg3U1i01Hcl/prMpDScXmqzkwJ1gUPbaho9fcN2PJX17rvPEVNQ0ZD8x2a9xYbrybHUY8CI9t6OhNLjALY9B8U+9Y0NR5JNlTVczwXbHjmyfRwNxgHP9gsUaIeM4YkT/jRKjLMjCbq2cti0Ns5s+QS7IVRRkf6wdwID/QxdS40iK3yo1zqsVriystMMv9oknNfGC4oB99U/ln2r/GC8xpYT4PaWcFqWJnfvXu5GZdSiQwW7SniBN7mPeN/t4jc6aMsfp8fHOWvuj+i2itqzUWhOdtPvCR60erapwe5tgit7rRN5TtONgu/ljEKaakQ0E41Lej5h9Hm4Y9R2dOGt7ALJEWW3KuLjOVBSYzQYA0173OfuSIrb7T7Q+bBodX1DRcCgbF78LYVBQb0q9a9U5kPDAbvhTxRzG2pKIhOieWoiiK4qvaeND4ARgONfoC1E0vP6Xt/5PLFkdbcNIWmC2Hq9TWdWc+MEfSckd/fUf/T56vc36Iu8CsqhZHD0XaZ5AU+Vef4MWAYe+SHhs8H6jfstJvMTomMsPiuT/+7mbheBttPxUnxjM8aNItM9ZuqQ+cD7rfvs5XVyaxJ5vfWlp5NzC7bL73YGB2PxFMxgOzeuZow/85rjR6KZL0gg4xBGa4l3BglqbOM896KnbhznhoY1g+FsTO4qafpcU527iGZ6wXWuoojsopm/uQQ+uptPEOi4KKpOVnpNnO0hiYrQ7KFsdH49wb3+6MMw+Z4bJJGL+hKIZlqxJiOE6ZI6XdpF/pYFF6qp0VxEm/fblFB0+ey0BgNjfBfPv7K/XvQ9o3jOuymrmdgsK4Vk1CYjuDc0m2ODdG/ripz1kNpJd+m+a2p8FgYFP1Q3psHpF/a0sa1khz+wYF4dryacJ9nOYvkSaeSWJZMsta/agEZhlxWCV+4Yrn500uKI2uXyKtD2c8Jogj1uRjxfAtK+UyMI++aVqx8IswT5tnGZi7GjeIv6L8cd/94HSfmonAHJ/4WPFQkKhoYI6k5b3t/T9Zn7bArKrhPSsWSm9QqpxS1XDgRNu251fOvXt6YeF10ciVc11hUXnVSptZCaQ9J7I/9J0+trKq/PqCUYqiKIpv9LgbK5evPWa1WKvLkpy75lTGLck529O+dnnljeNGR6coHzn5pulP1my1nBjc6nXD7Qd3z5o+JUdRFMX3o3VvOb6aqqrqvjWV4m818cmxbQPz8Xe32i2AOX7qvNbIJykVAMcGAGulwnZHpB+ufiMtwcOGtg9chYH59y7nZUgwMCcmqcCcwEKVYmBurastm/lIj/UowrQFZiMCMzIq4cAsHZdNY3rFqQK0WcFsA7N5rhfzOdvuSlefwd/S6BvKtr3daj4xStM8ugxRUsOqtEJg5gOzOLZzXGnl56bnsQvMKQQtaTOSCcwOB/14vTexJ7Gseaut65amWtHCW0YCs/y+xPtL+4aLSSNdTXMiJdVEuA3Mqqq27F514y3f27q32W7Ysd4ZO6pgSuXylb+zaagaDJ6t37Jy2pSJT718WP+MMxuY42f7KLmcJIllyeL9yuKPgAie79la85jULyTuPPp/+3Lzl9TsapDXhxu9p+2z6JPF1p8zr2uQxCzZ4t7ukCFdBuZrJtz8N3f79fWxqmN7SGwbxUNNtJbkzFPzxPNCZO0cLwRm8WQR99DhQAzMe9vTHpgthkQZK6d6/taqM1OQs7imznRksAjMR/a/aK4AV2wW2UpLSU441PdC1TybQSWKL3dM7avNcWfulDrh457WTb96c61EXA49zBZtcCPzJ0kTghqr/6RnGGzaudo8J0V0LNtwB2aJYRRGvEXX5SZp01WiG/IIJo1VC10cg8HAKuMk5Iqi+MtrB4OGlhjjGGDD/LhWPcAZDsyGL0U6Vr9l7FOZuXSz9AGJG6OfNboObdP2f735Uk1fYLYsrqyoaSAwI8OSCMxSJ4xvxY4P9fuLncbRFlaHwCwPOpWqnaVaSmmUpv4TtSM0vkaYfniu6oRNjzIcbjIemA2THFquhm0XmBvX/Ui4jPDlJhCePRKYrVdRqq3rEqda0bqXTV/ccAVm49xUToFZiSScbVohXN/Zk9Xzb5O+A+flzTWmHkX37AKzU+FxahOqJ1mKbyoGcbOIpS3TJ2ZdgCrNdJLEZEjGVSus+XIn7nVcGdVcPjNt3lO/NHUJOtCnwQuHOr8d/Udz41rWA7P2Ywme79lU/VDZrCesaoINC84LryjPaXTnonWveiAwi8+WnsDcPiyB2bzsrT6yRnsfLq7Q49TPK8rYNRtXOFXUmH4IqZfkmBtTrMiNVtLr3v/ET6YaT47Op3U3v3ob4lnJqSRbXLUoJ2/8svW7zVNeS63J5lktwqG+fVueEWLz2D2Rzz/DgVn6wA3XkJJP398uxuV46dqa1RiEiESGpFkvr6goir/86eo5U4VRgVLDq9iCKVYsGv5dVdXhW1bKdWAunCFMcGN5BjQH5s

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
>>返回首页<<
推荐阅读
 
 
频道精选
静静地坐在废墟上,四周的荒凉一望无际,忽然觉得,凄凉也很美
© 2005- 王朝网络 版权所有