Performance test result

Developer
Mar 24, 2009 at 8:13 AM
Edited Mar 24, 2009 at 8:41 AM
There is a progam tested insert, select, update and delete 1000 ~ 10000 records in database, through 3 kinds of data access ways.
The result is the time that used in millisecond.

Test with SQL Server in local machine.
SQL Server (local)
1000 2000 3000 4000 5000 6000 7000 8000 9000 10000
command insert 681 1063 1698 2171 3119 3301 3863 4792 5151 5736
select 11 16 18 22 30 35 45 46 59 63
update 597 1082 1597 834 1065 2226 1499 1745 1961 2137
delete 594 1400 1462 1926 3056 2938 4491 4050 4199 5342
ibatis insert 868 1468 2039 2679 3790 4251 4860 5441 6220 6825
select 43 33 44 60 76 90 121 118 148 156
update 700 1435 2014 2750 3864 4197 4929 5487 6625 6949
delete 673 1038 1546 2056 2698 3213 4664 4176 4899 5353
dac insert 1176 1362 1980 2701 3453 4183 4840 6078 6163 6879
select 69 39 59 73 98 115 138 170 175 196
update 791 1528 2261 2988 3856 4693 5497 6266 6932 7722
delete 553 1083 1627 2494 2744 3346 3860 4498 5820 5500
refer to the chart: http://dac.codeplex.com/Project/Download/AttachmentDownload.ashx?ProjectName=dac&WorkItemId=106&FileAttachmentId=18


Test with Oracle in remote machine through local network.
Oracle(remote)
1000 2000 3000 4000 5000 6000 7000 8000 9000 10000
command insert 1424 3378 5162 7251 8838 9112 9856 11351 13332 14087
select 75 142 213 309 358 427 512 568 647 728
update 2055 5214 9104 21794 21960 27944 31028 36827 46582 55289
delete 1557 3602 6368 14408 12833 16445 18519 21908 27523 31851
ibatis insert 1693 3447 5159 6865 8720 9964 10219 11556 13470 14701
select 101 166 251 343 428 503 583 691 760 857
update 1495 6443 12098 7252 8843 10535 10488 12226 13677 15189
delete 1333 3176 4804 5738 7360 7651 7806 9193 9936 11771
dac insert 1900 3713 5567 7998 10809 9282 10705 11942 13694 15139
select 125 175 270 343 428 524 601 688 763 862
update 1847 3769 6294 7635 9297 9790 11268 13280 14686 16404
delete 1388 3144 4664 5745 6787 7085 8148 8924 10420 11363
refer to chart: http://dac.codeplex.com/Project/Download/AttachmentDownload.ashx?ProjectName=dac&WorkItemId=106&FileAttachmentId=19


According this report, we can believe the performance of dac is not bad!