mysql, hsql, sqlite3, oracle 性能测试结果

chouy

今天只是大致测了一下,没想到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