Test Evn : Local windows.
DB: MySQL (Version 5.6.24).
Test point: Batch Insert;Select paging; Transaction(update and select).
Batch Insert(unit: ms) |
|||||
5k | 1w | 2w | 5w | 10w | |
Bee | 880 | 720 | 620 | 1420 | 4700 |
Bee | 359 | 358 | 484 | 1248 | 4000 |
Bee | 348 | 297 | 546 | 1279 | 3470 |
(AVG) | 529.00 | 458.33 | 550.00 | 1315.67 | 4056.67 |
MyBatis | 1513 | 1092 | 1466 | 1700 | Not Support |
MyBatis | 1045 | 577 | 812 | 1923 | Not Support |
MyBatis | 1021 | 470 | 1600 | 1850 | Not Support |
(AVG) | 1193 | 713 | 1292.67 | 1824.33 | Exception |
select(unit: ms) |
|||||
20 | 50 | 100 | 200 | 500 | |
Bee | 21 | 20 | 46 | 51 | 67 |
Bee | 16 | 78 | 32 | 16 | 61 |
Bee | 15 | 78 | 79 | 48 | 44 |
(AVG) | 17.33 | 58.67 | 52.33 | 38.33 | 57.33 |
MyBatis | 99 | 313 | 1795 | 2232 | 6160 |
MyBatis | 423 | 655 | 1622 | 2310 | 6260 |
MyBatis | 421 | 370 | 1221 | 2341 | 6230 |
(AVG) | 314.33 | 446.00 | 1546.00 | 2294.33 | 6216.67 |
Transaction(update and select) (unit: ms) |
|||||
20 | 50 | 100 | 200 | 500 | |
Bee | 1081 | 70 | 80 | 140 | 31600 |
Bee | 1076 | 78 | 78 | 173 | 31240 |
Bee | 1110 | 62 | 94 | 171 | 31688 |
(AVG) | 1089.00 | 70.00 | 84.00 | 161.33 | 31509.33 |
MyBatis | 1170 | 31 | 79 | 146 | 32404 |
MyBatis | 1092 | 33 | 79 | 141 | 32891 |
MyBatis | 1170 | 41 | 81 | 151 | 31171 |
(AVG) | 1144 | 35 | 79.67 | 146.00 | 32155.33 |
org\teasoft\orm\compare\model\Orders.java
org\teasoft\orm\compare\service\OrdersService.java
org\teasoft\orm\compare\bee\service\BeeOrdersService.java
org\teasoft\orm\compare\model\Orders.java
org\teasoft\orm\compare\mybatis\dao\OrdersDao.java
org\teasoft\orm\compare\mybatis\dao\OrdersMapper.java
org\teasoft\orm\compare\mybatis\dao\impl\OrdersDaoImpl.java
org\teasoft\orm\compare\service\OrdersService.java
org\teasoft\orm\compare\mybatis\service\MybatisOrdersService.java
Bee is an ORM framework.
Bee is an easy and high efficiency ORM framework. Easy for Stronger.
Coding Complexity is O(1),it means that Bee will do the Dao for you.
Bee see:
https://github.com/automvc/bee