对比mysql一般引擎与infobright

1.mysql与infobirght的配置

采用虚拟机：

mysql：10.28.174.74 10.28.174.237

内存： 4g 3g

cpu：双核 cpu MHz : 3309.71

2.测试程序python

3.测试数据700w左右结果1：

infobright：

----start time:Tue, 23 Jul 2013 13:51:02 +0000
----end time:Tue, 23 Jul 2013 13:51:04 +0000
----start time:Tue, 23 Jul 2013 13:51:04 +0000
exec start0Tue, 23 Jul 2013 13:51:04 +0000
exec start50000Tue, 23 Jul 2013 13:51:05 +0000
exec start100000Tue, 23 Jul 2013 13:51:06 +0000
exec start150000Tue, 23 Jul 2013 13:51:07 +0000
exec start200000Tue, 23 Jul 2013 13:51:09 +0000
----end time:Tue, 23 Jul 2013 13:51:11 +0000 
           

mysql:

----start time:Tue, 23 Jul 2013 13:51:32 +0000
----end time:Tue, 23 Jul 2013 13:51:42 +0000
----start time:Tue, 23 Jul 2013 13:51:42 +0000
exec start0Tue, 23 Jul 2013 13:51:42 +0000
exec start50000Tue, 23 Jul 2013 13:51:44 +0000
exec start100000Tue, 23 Jul 2013 13:51:49 +0000
exec start150000Tue, 23 Jul 2013 13:51:55 +0000
exec start200000Tue, 23 Jul 2013 13:52:04 +0000
----end time:Tue, 23 Jul 2013 13:52:12 +0000
           

从结果得出：

[table]

||||mysql || infobright

||count：|| 10s || 2s

||fetch_data(20w左右分页5w):||30s || 7s

[/table]