【插入速度测试】
测试 QDAC.TQDataSet... 每万条用时(ms):94.6 97.2 99.4 99.3 104.3 98.7 101.3 101.5 104.4 100.3 总计用时(ms):1001.0 测试 UniDAC.TQDataSet... 每万条用时(ms):116.1 118.1 117.6 117.4 118.6 117.1 117.9 118.9 116.9 118.3 总计用时(ms):1176.9 测试 ADO.TADODataSet... 每万条用时(ms):794.0 779.6 779.0 775.8 753.6 786.9 781.2 791.5 793.6 764.3 总计用时(ms):7799.5 测试 FDAC.TFDMemTable... 每万条用时(ms):99.6 98.1 98.4 97.9 99.2 97.9 98.3 97.8 98.7 98.0 总计用时(ms):983.9 测试 FDAC.TKBMMemTable... 每万条用时(ms):107.3 108.2 112.7 113.0 114.3 110.4 111.6 109.0 109.5 114.7 总计用时(ms):1110.7 测试 DataSnap.TClientDataSet... 每万条用时(ms):162.7 298.5 451.6 559.1 681.1 821.5 969.0 1128.2 1334.3 1855.5 总计用时(ms):8261.5 测试 EhLib.TMemTableEh... 每万条用时(ms):1133.4 2394.9 3567.3 5641.9 6611.8 7974.3 9998.5 11156.7 12858.7 14947.1 总计用时(ms):76284.6 QDAC vs UniDAC:1.18 X QDAC vs ADO:7.79 X QDAC vs FDAC:0.98 X QDAC vs KBM:1.11 X QDAC vs DataSnap:8.25 X QDAC vs EhLib:76.21 X
【追加速度测试】
测试 QDAC.TQDataSet... 每万条用时(ms):79.9 81.7 85.5 83.0 82.1 82.2 81.0 81.6 81.2 84.3 总计用时(ms):822.5 测试 UniDAC.TVirtualTable... 每万条用时(ms):111.2 111.3 114.0 111.1 109.4 111.1 109.6 110.7 110.1 110.9 总计用时(ms):1109.4 测试 ADO.TADODataSet... 每万条用时(ms):823.7 833.3 844.1 831.6 821.6 818.3 821.8 819.8 824.3 846.4 总计用时(ms):8284.9 测试 FDAC.TFDMemTable... 每万条用时(ms):98.6 96.8 97.3 98.5 130.3 99.5 98.8 98.0 98.5 97.2 总计用时(ms):1013.5 测试 FDAC.TKBMMemTable... 每万条用时(ms):102.4 101.1 101.8 129.8 107.8 104.6 102.2 102.3 101.5 101.9 总计用时(ms):1055.4 测试 DataSnap.TClientDataSet... 每万条用时(ms):107.0 91.7 87.4 90.0 89.9 89.4 88.5 91.4 93.0 89.0 总计用时(ms):917.3 测试 EhLib.TMemTableEh... 每万条用时(ms):193.8 194.4 197.4 203.1 204.1 194.6 195.7 198.9 199.9 205.1 总计用时(ms):1987.0 QDAC vs UniDAC:1.35 X QDAC vs ADO:10.07 X QDAC vs FDAC:1.23 X QDAC vs KBM:1.28 X QDAC vs DataSnap:1.12 X QDAC vs EhLib:2.42 X
【定位测试】
QDAC.Locate 1470.5ms UniDAC.Locate 3146.6ms ADO.Locate 340.7ms FireDAC.Locate 2548.9ms KBM.Locate 3113.4ms DataSnap.Locate 3589.7ms EhLib.Locate 3826.8ms QDAC vs ADO:0.23 X QDAC vs FDAC:1.73 X QDAC vs KBM:2.12 X QDAC vs DataSnap:2.44 X QDAC vs EhLib:2.60 X
【排序测试】
QDAC.Sort 866.7ms UniDAC.IndexFieldDefs 418.8ms ADO.Sort 65.2ms FireDAC.IndexName 319.7ms KBM.SortFields 0ms(未深查原因） DataSnap.IndexName 67.9ms EhLib.SortOrder 1440.4ms QDAC vs ADO:0.08 X QDAC vs FDAC:0.37 X QDAC vs KBM:0.00 X QDAC vs DataSnap:0.08 X QDAC vs EhLib:1.66 X
【过滤测试】
QDAC.Filter 50.9ms UniDAC.Filter 96.2ms ADO.Filter 144ms FireDAC.Filter 117.9ms KBM.Filter 529ms DataSnap.Filter 45.5ms EhLib.Filter 2102.5ms QDAC vs ADO:2.83 X QDAC vs FDAC:2.32 X QDAC vs KBM:10.39 X QDAC vs DataSnap:0.89 X QDAC vs EhLib:41.31 X
【保存到流速度测试】
QDAC 263.8ms , 6.35MB UniDAC 3695.8ms , 13.34MB ADO 759.2ms , 7.75MB FireDAC 181.2ms , 9.76MB KBM 868.8ms , 7.72MB ClientDataSet 109.7ms , 8.14MB EhLib 440ms , 6.67MB QDAC vs ADO:2.88 X QDAC vs FDAC:0.69 X QDAC vs KBM:3.29 X QDAC vs DataSnap:0.42 X QDAC vs EhLib:1.67 X