张秋桥：
我测试了如下语句，估计2到3秒，返回8523条记录。你什么CPU?什么内存？
[阅读: 669] 2008-12-17 05:05:55
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 = 'emotion.programmer'
group by msg_baseid
order by flast desc
limit 10000,1000)
)
order by msg_baseid desc
| -ICP -IDC -ISP |