大家请帮我分析一这个是怎么回事,时间差好多,
1: select pkid from logininfo where 1=1 AND isdel=0 AND regtype = 8 order by pkid desc limit 30,15
返回条数:15 执行时间:00:00:00.07800442:select pkid from logininfo where 1=1 AND isdel=0 AND regtype = 8 order by pkid desc limit 45,15
返回条数:11 执行时间:00:00:09.2225275 为什么有数据时这么快,数据不全或没数据时这么慢,且差好多,太可怕了请大虾,帅哥们帮忙解答解答!谢先!
1: select pkid from logininfo where 1=1 AND isdel=0 AND regtype = 8 order by pkid desc limit 30,15
返回条数:15 执行时间:00:00:00.07800442:select pkid from logininfo where 1=1 AND isdel=0 AND regtype = 8 order by pkid desc limit 45,15
返回条数:11 执行时间:00:00:09.2225275 为什么有数据时这么快,数据不全或没数据时这么慢,且差好多,太可怕了请大虾,帅哥们帮忙解答解答!谢先!
explain select pkid from logininfo where 1=1 AND isdel=0 AND regtype = 8 order by pkid desc limit 45,15;
explain select pkid from logininfo where 1=1 AND isdel=0 AND regtype = 8 order by pkid desc limit 30,15贴出以供分析。