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_operation_log中的索引 #80

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

优化sys_operation_log中的索引 #80

wtune opened this issue Mar 20, 2020 · 0 comments

Comments

@wtune
Copy link

wtune commented Mar 20, 2020 •
edited

问题

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

1.sys_operation_log.create_time

从OperationLogService#getOperationLogs可以看出在查询操作日志的时候会根据create_time来查询，因此需要在create_time字段上添加索引从而加快相关查询效率。

解决方法

在下列字段添加索引
sys_operation_log.create_time
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