昨天听到说用索引,之前没用过,第一次用,感觉很新奇~~,来测试下是不是有那么牛~~
1.建立的一张表
CREATE TABLE `wh_test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`pwd` varchar(32) NOT NULL,
`tel` varchar(32) NOT NULL,
`age` varchar(32) NOT NULL,
`sex` varchar(32) NOT NULL,
`hight` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=11670 DEFAULT CHARSET=utf8;
2,插入数据(总共插入了11669条数据,其中有一条name字段为xxx)
for ($i=0; $i < 1000; $i++) {
$data=array('name'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),
'pwd'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),
'tel'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),
'age'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),
'sex'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),
'hight'=>md5(rand(1,1000)*rand(1001,2000)*rand(2001,3000)*rand(3001,4000)),
);
M('test')->add($data);
}
3.查询
SELECT * FROM `wh_test` WHERE `name`='xxx'
用时
4.建立索引
ALTER TABLE `wh_test` ADD INDEX `name`(`name`)
5.查询
SELECT * FROM `wh_test` WHERE `name`='xxx'
用计算器算了下,隔了这么多
真的是 很叼~~~
怎么图片上传了没用......
反正就是隔了31倍多的时间,我只测试了一遍