cloudfavorites / favorites-web

云收藏 Spring Boot 2.X 开源项目
http://favorites.ren/
4.82k stars 1.74k forks source link

看到不少很长的SQL #94

Closed linkerlin closed 4 years ago

linkerlin commented 6 years ago

例如: Hibernate: select collect0_.id as col_00, collect0_.title as col_10, collect0_.type as col_20, collect0_.url as col_30, collect0_.logo_url as col_40, collect0_.user_id as col_50, collect0_.remark as col_60, collect0_.description as col_70, collect0_.last_modify_time as col_80, collect0_.create_time as col_90, user1_.user_name as col_100, user1_.profile_picture as col_110, favorites2_.id as col_120, favorites2_.name as col_130 from collect collect0 cross join user user1 cross join favorites favorites2 where collect0.userid=user1.id and collect0_.favoritesid=favorites2.id and collect0_.isdelete='NO' and collect0.userid=? order by collect0.id desc limit ?

感觉,只要用户数量多喜欢的收藏多了,就会有性能问题。