龙之吻：
继续请教,现在已经按照db牛说的建立了索引,改成了join 但是现在速度还是慢的很啊.第一次查询要2分钟多,以后每次翻页也要10几秒
[阅读: 785] 2008-12-16 02:25:34
select a.msg_id,a.msg_parentid,a.msg_baseid,a.msg_title,a.msg_author,a.msg_readtimes,a.msg_time,a.msg_content_words,a.msg_content,a.msg_image from main_data a left join (select msg_baseid, msg_id from main_data where msg_boradid = '"+boradID+"' group by msg_baseid order by msg_id desc limit "+str(int_m)+",11) b on a.msg_baseid=b.msg_baseid where b.msg_baseid is not null order by a.msg_baseid desc, b.msg_baseid asc
机器人，
这首歌学会了没有？
我们的目标是->没有蛀牙！
| -ICP -IDC -ISP |