56,677
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `test` (
`sss` varchar(20) NOT NULL,
PRIMARY KEY (`sss`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
生成100W数据
CREATE PROCEDURE `aa`()
BEGIN
DECLARE i int;
DECLARE c int;
set i = 0;
set autocommit = 0;
while i < 1000 do
set c = 0;
while c < 1000 do
insert into test VALUES( LPAD(i*1000+c,10,'0'));
set c=c+1;
end while;
commit;
set i=i+1;
end while;
set autocommit = 1;
END
查询
select * from test WHERE sss > '0000100023' and sss < '0000200023' ORDER BY rand() LIMIT 100
耗时0.12S, 服务器是阿里云RDS最低配置。
ORDER BY rand() LIMIT N会慢吗?