Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

优化sys_role中的索引 #88

Open
wtune opened this issue Mar 20, 2020 · 0 comments
Open

优化sys_role中的索引 #88

wtune opened this issue Mar 20, 2020 · 0 comments

Comments

@wtune
Copy link

wtune commented Mar 20, 2020

问题

表sys_role中缺少一些需要的索引，通过测试，我们发现加上这些索引可以极大地提高相关查询的性能(高达80%)，需要添加的索引分别如下所示：

1.sys_role.sort

从RoleMapper可以看出在查询sys_role时常用sort作为排序依据，因此需要在该字段添加索引提升相关查询的性能。

解决方法

在下列字段添加索引
sys_role.sort
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@wtune