性能提升－－意见收集贴（数据超过4000条，就明显慢了）,代码已贴出

# private String sql = "select t1.* from OuterTask t1 where  t1.tag regexp :tags union all select t2.* from InnerTask t2 where  t2.tag regexp :tags order by publishDate desc  ";  
#   
#     private String sqlCount = "select count(t.id) from ("  
#             + " select t1.id from OuterTask t1 where  t1.tag regexp :tags union all select t2.id from InnerTask t2 where  t2.tag regexp :tags ) t";  
#