| 数据学习者官方网站(Datalearner)

https://dat1.co/blog/llm-quantization-comparison

https://pagespeed.web.dev/analysis/https-www-datalearner-com-blog_list/73yuk48d4f?form_factor=mobile

我在springmvc的最后数据库查询实现中实现了如下的SQL：select c.blog_id, c.blog_title, c.blog_uid, c.blog_author, c.blog_abstract, c.blog_read, c.blog_time, c.avatar_img, group_concat(\"<a href='blog_list/tag/\",c.label_name,\"'>\",c.label_name,\"</a>\" SEPARATOR '/') as blog_tags from (select a.*, b.label_name from (select a.blog_id, a.blog_title, a.blog_uid, a.blog_author, a.blog_abstract, a.blog_read, a.blog_time, a.avatar_img from blog a where is_pub=1 order by blog_time desc limit 0,10) a, (SELECT b.blog_id, b.label_name FROM datalearner.blog_labels b) b where a.blog_id=b.blog_id ) c group by c.blog_id order by blog_time desc; 但是我觉得性能比较差，我需要按照时间查询特定分页的博客，一次20个博客，每个博客关联的标签数量通常不超过5个，如何优化才更合理

```
public List<Blog> getBlogList(int startPage, int rows, int type) {

String sql = "";
 if (type == 0) { //默认，按时间排序
 sql = "select c.blog_id, c.blog_title, c.blog_uid, c.blog_author, c.blog_abstract, c.blog_read, c.blog_time, c.avatar_img, " +
 "group_concat(\"<a href='blog_list/tag/\",c.label_name,\"'>\",c.label_name,\"</a>\" SEPARATOR '/') as blog_tags " +
 "from " +
 "(select a.*, b.label_name from " +
 "(select a.blog_id, a.blog_title, a.blog_uid, a.blog_author, a.blog_abstract, a.blog_read, a.blog_time, a.avatar_img from blog a " +
 "where is_pub=1 order by blog_time desc limit ?,?) a, (SELECT b.blog_id, b.label_name FROM datalearner.blog_labels b) b " +
 "where a.blog_id=b.blog_id ) c group by c.blog_id order by blog_time desc;";
 } else if (type == 1) { //按浏览量降序
 sql = "select * from blog a,(SELECT b.blog_id,group_concat(\"<a href='blog_list/tag/\",b.label_name,\"'>\",b.label_name,\"</a>\" SEPARATOR '/') as blog_tags FROM datalearner.blog_labels b group by blog_id ) b where a.blog_id=b.blog_id and is_pub=1 order by blog_read desc limit ?,?";
 } else if (type == 2) { //按浏览量升序
 sql = "select * from blog a,(SELECT b.blog_id,group_concat(\"<a href='blog_list/tag/\",b.label_name,\"'>\",b.label_name,\"</a>\" SEPARATOR '/') as blog_tags FROM datalearner.blog_labels b group by blog_id ) b where a.blog_id=b.blog_id and is_pub=1 order by blog_read limit ?,?";
 } else if (type == 3) { //按浏览量升序
 sql = "select * from blog a,(SELECT b.blog_id,group_concat(\"<a href='blog_list/tag/\",b.label_name,\"'>\",b.label_name,\"</a>\" SEPARATOR '/') as blog_tags FROM datalearner.blog_labels b group by blog_id ) b where a.blog_id=b.blog_id and is_pub=1 order by blog_time limit ?,?";
 }

Object[] params = {startPage, rows};

try {
 return getQueryRunner().query(sql, new BeanListHandler<Blog>(Blog.class), params);
 } catch (SQLException e) {
 e.printStackTrace();
 return null;
 }

}
```

欢迎大家关注DataLearner官方微信，接受最新的AI技术推送

相关博客

最热博客