search

atjiu / pybbs

更实用的Java开发的社区(论坛)，Better use of Java development community (forum)
GNU Affero General Public License v3.0
1.84k stars 706 forks source link

添加permission.pid索引，提升查询性能 #113

Closed wtune closed 4 years ago

wtune commented 4 years ago

在permission表的pid上添加索引，可以提升通过selectByPid进行查询的操作的性能，因为该SQL查询通过指定pid查找。

https://github.com/tomoya92/pybbs/blob/cf5a7dcbaff3b808a9e80938763dcdc35d9ee2e2/src/main/java/co/yiiu/pybbs/service/impl/PermissionService.java#L44-L50