中国开发网: 论坛: 程序员情感CBD: 贴子 679957
龙之吻
[技术帖]请教各位大牛,下面的sql语句如何优化?数据到了50w条后速度就很慢了,第一次查要好几十秒钟
"select msg_id,msg_parentid,msg_baseid,msg_title,msg_author,msg_readtimes,msg_time,msg_content_words,msg_content,msg_image from main_data where msg_baseid in (select msg_baseid from( select msg_baseid, max(msg_id) as flast from main_data where msg_boradid = '"+boradID+"' group by msg_baseid order by flast desc limit "+str(int_m)+",10)) order by msg_baseid desc"
表结构如下:
CREATE TABLE "main_data"
(
"msg_id" INTEGER PRIMARY KEY,
"msg_parentid" INTEGER,
"msg_baseid" INTEGER,
"msg_boradid" VARCHAR(40),
"msg_title" VARCHAR(250),
"msg_content" MEMO,
"msg_content_words" INTEGER,
"msg_time" TIMESTAMP,
"msg_author" VARCHAR(40),
"msg_image" VARCHAR(40),
"msg_readtimes" INTEGER
);


机器人,这首歌学会了没有?

我们的目标是->没有蛀牙!

相关信息:


欢迎光临本社区,您还没有登录,不能发贴子。请在 这里登录