对照mysql一般引擎与infobright

对比mysql一般引擎与infobright1.mysql与infobirght的配置采用虚拟机:mysql:10.28.174.74 10.28.174.237内

对比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:32 +0000----end time:Tue, 23 Jul 2013 13:51:42 +0000----start time:Tue, 23 Jul 2013 13:51:42 +0000exec start0Tue, 23 Jul 2013 13:51:42 +0000exec start50000Tue, 23 Jul 2013 13:51:44 +0000exec start100000Tue, 23 Jul 2013 13:51:49 +0000exec start150000Tue, 23 Jul 2013 13:51:55 +0000exec start200000Tue, 23 Jul 2013 13:52:04 +0000----end time:Tue, 23 Jul 2013 13:52:12 +0000

从结果得出:
mysql             infobrightcount: 10s 2sfetch_data(20w左右分页5w):30s       7s