今天只是大致测了一下,没想到innodb性能竞这么差,慢10倍.肯定是什么参数设置不对.
Mysql: MyISAM
insert 1000s data used 3671ms
batch insert 1000s data used 812ms
Mysql: Innodb
insert 1000s data used 48700ms
batch insert 1000s data used 44500ms
memory:
insert 1000s data used 3183ms
batch insert 1000s data used 655ms
HsqlDB: MEM
insert 1000s data used 921ms
batch insert 1000s data used 219ms
HsqlDB: Server
insert 1000s data used 3464ms
batch insert 1000s data used 281ms
HsqlDB: In-Process
insert 1000s data used 1436ms
batch insert 1000s data used 281ms
oracle:
insert 1000s data used 7676ms
batch insert 1000s data used 390ms
再加一个
sqlite3:
insert 1000s data used 181673ms
batch insert 1000s data used 167653ms
阅读(2390) | 评论(0) | 转发(0) |
