我直接用sqlite3提供的命令行的工具查询第一次也要40多秒
这是sqlite developer输出的信息:
-- 2008-12-17 14:25:32 --
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 = 'emotion.programmer' group by msg_baseid order by msg_id desc limit 100,10) 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
--Execute Time(8.990 sec(s))--

-- 2008-12-17 14:22:40 --
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 = 'emotion.programmer' group by msg_baseid order by msg_id desc limit 5,10) 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
--Execute Time(8.796 sec(s))--

-- 2008-12-17 14:22:23 --
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 = 'emotion.programmer' group by msg_baseid order by msg_id desc limit 4,10) 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
--Execute Time(8.760 sec(s))--

-- 2008-12-17 14:22:04 --
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 = 'emotion.programmer' group by msg_baseid order by msg_id desc limit 3,10) 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
--Execute Time(8.926 sec(s))--

-- 2008-12-17 14:21:04 --
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 = 'emotion.programmer' group by msg_baseid order by msg_id desc limit 2,10) 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
--Execute Time(8.802 sec(s))--

-- 2008-12-17 14:20:35 --
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 = 'emotion.programmer' group by msg_baseid order by msg_id desc limit 1,10) 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
--Execute Time(8.847 sec(s))--

这部分是我程序输出的信息:
GetDataFromDB : 91.8280000687
Create Tree : 1.0150001049
GetDataFromDB : 24.0469999313
Create Tree : 0.234999895096
GetDataFromDB : 11.8129999638
Create Tree : 0.203000068665
GetDataFromDB : 11.9059998989
Create Tree : 0.18799996376
GetDataFromDB : 12.0160000324
Create Tree : 0.280999898911
GetDataFromDB : 11.9690001011
Create Tree : 0.0309998989105