sql
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` varchar(255) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`post` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
2w条数据查询中间数据:A组:总时长:273ms;B组:总时长:258ms[注:查询是根据id查询的,分区字段是post]
2w条数据查询中间数据:A组:总时长:总时长:269;B组:总时长:503ms[注:查询是根据post查询的,分区字段是post]
2w条数据查询中间数据:A组:总时长:264ms; B组:总时长:总时长:280ms[注:查询是根据post和手机号查询的,分区字段是post]
http://download.csdn.net/detail/wgyscsf/9620006
cs