日期:2014-05-16  浏览次数:20720 次

对比mysql一般引擎与infobright--2
切换到同一台物理机测试
1.物理机的情况:
  内存:16g
  cpu:4核 cpu MHz : 800.000
2.建同样的库表
3.造数据5000w测试
 
sql数量mysqlinfobright
在服务器上全表count5000w25.08s0.08s
python执行:d_o_lastordertime>='2012-06-19' and s_usr_level>60 and i_u_verified=1 036s<1s
count:i_u_sex=1 and s_o_usermob_type=2 and i_o_ordesnum_3m=4  and i_u_verified=1 125443729s;29s;29s4s;4s;4s
fetch_data(分页5w):i_u_sex=1 and s_o_usermob_type=2 and i_o_ordesnum_3m=4  and i_u_verified=1 50w77s;76;75s42s;37s;41s 

4.