{"id":2407,"date":"2015-05-05T17:15:05","date_gmt":"2015-05-05T09:15:05","guid":{"rendered":"http:\/\/blog.qdac.cc\/?p=2407"},"modified":"2015-05-05T17:16:21","modified_gmt":"2015-05-05T09:16:21","slug":"qdb-%e4%b8%80%e4%b8%aa%e7%bb%bc%e5%90%88%e6%80%a7%e8%83%bd%e6%b5%8b%e8%af%95-qdac-tqdataset-%e6%af%8f%e4%b8%87%e6%9d%a1%e7%94%a8%e6%97%b6ms94-6-97-2-99-4-99-3-104-3-98-7-101-3-101-5-104-4-100","status":"publish","type":"post","link":"https:\/\/blog.qdac.cc\/?p=2407","title":{"rendered":"QDB &#8211; QDataSet \u7efc\u5408\u6027\u80fd\u6d4b\u8bd5"},"content":{"rendered":"<p>\u3010\u63d2\u5165\u901f\u5ea6\u6d4b\u8bd5\u3011<\/p>\n<pre class=\"lang:tex decode:true\">\u6d4b\u8bd5 QDAC.TQDataSet...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):94.6 97.2 99.4 99.3 104.3 98.7 101.3 101.5 104.4 100.3 \r\n\u603b\u8ba1\u7528\u65f6(ms):1001.0\r\n\u6d4b\u8bd5 UniDAC.TQDataSet...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):116.1 118.1 117.6 117.4 118.6 117.1 117.9 118.9 116.9 118.3 \r\n\u603b\u8ba1\u7528\u65f6(ms):1176.9\r\n\u6d4b\u8bd5 ADO.TADODataSet...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):794.0 779.6 779.0 775.8 753.6 786.9 781.2 791.5 793.6 764.3 \r\n\u603b\u8ba1\u7528\u65f6(ms):7799.5\r\n\u6d4b\u8bd5 FDAC.TFDMemTable...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):99.6 98.1 98.4 97.9 99.2 97.9 98.3 97.8 98.7 98.0 \r\n\u603b\u8ba1\u7528\u65f6(ms):983.9\r\n\u6d4b\u8bd5 FDAC.TKBMMemTable...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):107.3 108.2 112.7 113.0 114.3 110.4 111.6 109.0 109.5 114.7 \r\n\u603b\u8ba1\u7528\u65f6(ms):1110.7\r\n\u6d4b\u8bd5 DataSnap.TClientDataSet...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):162.7 298.5 451.6 559.1 681.1 821.5 969.0 1128.2 1334.3 1855.5 \r\n\u603b\u8ba1\u7528\u65f6(ms):8261.5\r\n\u6d4b\u8bd5 EhLib.TMemTableEh...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):1133.4 2394.9 3567.3 5641.9 6611.8 7974.3 9998.5 11156.7 12858.7 14947.1 \r\n\u603b\u8ba1\u7528\u65f6(ms):76284.6\r\nQDAC vs UniDAC:1.18 X\r\nQDAC vs ADO:7.79 X\r\nQDAC vs FDAC:0.98 X\r\nQDAC vs KBM:1.11 X\r\nQDAC vs DataSnap:8.25 X\r\nQDAC vs EhLib:76.21 X<\/pre>\n<p>\u3010\u8ffd\u52a0\u901f\u5ea6\u6d4b\u8bd5\u3011<\/p>\n<pre class=\"lang:tex decode:true \">\u6d4b\u8bd5 QDAC.TQDataSet...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):79.9 81.7 85.5 83.0 82.1 82.2 81.0 81.6 81.2 84.3 \r\n\u603b\u8ba1\u7528\u65f6(ms):822.5\r\n\u6d4b\u8bd5 UniDAC.TVirtualTable...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):111.2 111.3 114.0 111.1 109.4 111.1 109.6 110.7 110.1 110.9 \r\n\u603b\u8ba1\u7528\u65f6(ms):1109.4\r\n\u6d4b\u8bd5 ADO.TADODataSet...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):823.7 833.3 844.1 831.6 821.6 818.3 821.8 819.8 824.3 846.4 \r\n\u603b\u8ba1\u7528\u65f6(ms):8284.9\r\n\u6d4b\u8bd5 FDAC.TFDMemTable...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):98.6 96.8 97.3 98.5 130.3 99.5 98.8 98.0 98.5 97.2 \r\n\u603b\u8ba1\u7528\u65f6(ms):1013.5\r\n\u6d4b\u8bd5 FDAC.TKBMMemTable...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):102.4 101.1 101.8 129.8 107.8 104.6 102.2 102.3 101.5 101.9 \r\n\u603b\u8ba1\u7528\u65f6(ms):1055.4\r\n\u6d4b\u8bd5 DataSnap.TClientDataSet...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):107.0 91.7 87.4 90.0 89.9 89.4 88.5 91.4 93.0 89.0 \r\n\u603b\u8ba1\u7528\u65f6(ms):917.3\r\n\u6d4b\u8bd5 EhLib.TMemTableEh...\r\n\u6bcf\u4e07\u6761\u7528\u65f6(ms):193.8 194.4 197.4 203.1 204.1 194.6 195.7 198.9 199.9 205.1 \r\n\u603b\u8ba1\u7528\u65f6(ms):1987.0\r\nQDAC vs UniDAC:1.35 X\r\nQDAC vs ADO:10.07 X\r\nQDAC vs FDAC:1.23 X\r\nQDAC vs KBM:1.28 X\r\nQDAC vs DataSnap:1.12 X\r\nQDAC vs EhLib:2.42 X<\/pre>\n<p>\u3010\u5b9a\u4f4d\u6d4b\u8bd5\u3011<\/p>\n<pre class=\"lang:delphi decode:true\">QDAC.Locate 1470.5ms\r\nUniDAC.Locate 3146.6ms\r\nADO.Locate 340.7ms\r\nFireDAC.Locate 2548.9ms\r\nKBM.Locate 3113.4ms\r\nDataSnap.Locate 3589.7ms\r\nEhLib.Locate 3826.8ms\r\n\r\nQDAC vs ADO:0.23 X\r\nQDAC vs FDAC:1.73 X\r\nQDAC vs KBM:2.12 X\r\nQDAC vs DataSnap:2.44 X\r\nQDAC vs EhLib:2.60 X<\/pre>\n<p>\u3010\u6392\u5e8f\u6d4b\u8bd5\u3011<\/p>\n<pre class=\"lang:delphi decode:true\">QDAC.Sort 866.7ms\r\nUniDAC.IndexFieldDefs 418.8ms\r\nADO.Sort 65.2ms\r\nFireDAC.IndexName 319.7ms\r\nKBM.SortFields 0ms(\u672a\u6df1\u67e5\u539f\u56e0\uff09\r\nDataSnap.IndexName 67.9ms\r\nEhLib.SortOrder 1440.4ms\r\nQDAC vs ADO:0.08 X\r\nQDAC vs FDAC:0.37 X\r\nQDAC vs KBM:0.00 X\r\nQDAC vs DataSnap:0.08 X\r\nQDAC vs EhLib:1.66 X<\/pre>\n<p>\u3010\u8fc7\u6ee4\u6d4b\u8bd5\u3011<\/p>\n<pre class=\"lang:delphi decode:true \">QDAC.Filter 50.9ms\r\nUniDAC.Filter 96.2ms\r\nADO.Filter 144ms\r\nFireDAC.Filter 117.9ms\r\nKBM.Filter 529ms\r\nDataSnap.Filter 45.5ms\r\nEhLib.Filter 2102.5ms\r\nQDAC vs ADO:2.83 X\r\nQDAC vs FDAC:2.32 X\r\nQDAC vs KBM:10.39 X\r\nQDAC vs DataSnap:0.89 X\r\nQDAC vs EhLib:41.31 X\r\n<\/pre>\n<p>\u3010\u4fdd\u5b58\u5230\u6d41\u901f\u5ea6\u6d4b\u8bd5\u3011<\/p>\n<pre class=\"lang:delphi decode:true \">QDAC 263.8ms , 6.35MB\r\nUniDAC 3695.8ms , 13.34MB\r\nADO 759.2ms , 7.75MB\r\nFireDAC 181.2ms , 9.76MB\r\nKBM 868.8ms , 7.72MB\r\nClientDataSet 109.7ms , 8.14MB\r\nEhLib 440ms , 6.67MB\r\nQDAC vs ADO:2.88 X\r\nQDAC vs FDAC:0.69 X\r\nQDAC vs KBM:3.29 X\r\nQDAC vs DataSnap:0.42 X\r\nQDAC vs EhLib:1.67 X<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3010\u63d2\u5165\u901f\u5ea6\u6d4b\u8bd5\u3011 \u6d4b\u8bd5 QDAC.TQD [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[69,8,9,66],"tags":[400,117,399],"class_list":["post-2407","post","type-post","status-publish","format-standard","hentry","category-c-builder","category-delphi","category-qdac","category-qdb","tag-qdataset","tag-117","tag-399"],"views":5094,"_links":{"self":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/2407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2407"}],"version-history":[{"count":2,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/2407\/revisions"}],"predecessor-version":[{"id":2409,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/2407\/revisions\/2409"}],"wp:attachment":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}