对比mysql一般引擎与infobright--2
切换到同一台物理机测试
1.物理机的情况：
内存：16g
cpu:4核 cpu MHz : 800.000
2.建同样的库表
3.造数据5000w测试
sql数量mysqlinfobright在服务器上全表count5000w25.08s0.08spython执行:d_o_lastordertime>='2012-06-19' and s_usr_level>60 and i_u_verified=1 036s<1scount: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;4sfetch_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.
