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

单一主键skip过大时候的优化 #213

Open
xuejmnet opened this issue Oct 28, 2022 · 5 comments
Open

单一主键skip过大时候的优化 #213

xuejmnet opened this issue Oct 28, 2022 · 5 comments

Comments

@xuejmnet
Copy link
Collaborator

No description provided.

@xuejmnet
Copy link
Collaborator Author

两次查询第一次查询主键第二次查询对象

@shuxinqin
Copy link

这个不错，我那个ORM已经实现，不知道效率提升如何~

@xuejmnet
Copy link
Collaborator Author

@shuxinqin 大佬有机会拜读一下理论上大宽表应该能提升不小，转成unionall其实也不错

@xuejmnet xuejmnet changed the title 单一组件skip过大时候的优化 单一主键skip过大时候的优化 Oct 29, 2022
@shuxinqin
Copy link

用 unionall 可以减少连接，但是一直有个疑问，unionall 中的每个查询时并行还是串行执行的？我在网上没搜到相关的资料说明，如果是串行，如果表多会不会影响效率？

@xuejmnet
Copy link
Collaborator Author

xuejmnet commented Nov 2, 2022

@shuxinqin 会影响效率同一个链接一般对应数据库一个线程但是具体内部执行应该是串行所以也在考虑毕竟时间上面估计要花费不少，都是链接会减少到一，感觉还是并行聚合比较好

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
2 participants
@shuxinqin @xuejmnet