龙之吻:
[技术帖]请教各位大牛,下面的sql语句如何优化?数据到了50w条后速度就很慢了,第一次查要好几十秒钟
[阅读: 1253] 2008-10-30 05:58:16
"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
);

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

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