create table aaa as
select msg_boradid,msg_baseid,max(msg_id) msg_id from main_data
group by msg_boradid,msg_baseid
order by msg_boradid,msg_id desc

建索引

上面这东东，SQLite还真不知道怎样把它弄成视图，速度会快。


-- 2008-12-18 14:53:13 --
select a.*
from main_data a
inner join (select msg_baseid,msg_id from aaa
where msg_boradid = 'emotion.programmer'
order by msg_id desc limit 100,10) b on a.msg_baseid=b.msg_baseid
order by a.msg_baseid desc, b.msg_baseid asc
--Execute Time(0.236 sec(s))--

但最后的排序，俺还是不明白。
order by a.msg_baseid desc, b.msg_baseid asc