Skip to content
New issue

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

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

Already on GitHub? # to your account

用户数据量较大时,功能测试报错 #3196

Closed
915999136 opened this issue Nov 19, 2021 · 8 comments
Closed

用户数据量较大时,功能测试报错 #3196

915999136 opened this issue Nov 19, 2021 · 8 comments

Comments

@915999136
Copy link

915999136 commented Nov 19, 2021

版本号:

2.4.6,3.0都有

问题描述:

Online表单开发,当表单里使用了用户选择控件时,打开功能测试页面报错,用户表数据量7万左右
请求网址: http://localhost:9999/online/cgform/api/getColumns/18f064d1ef424c93ba7a16148851664f?_t=1637299508
访问超时,请稍后再试!

截图&代码:

image

image

友情提示(为了提高issue处理效率):

  • 未按格式要求发帖,会被直接删掉;
  • 请自己初判问题描述是否清楚,是否方便我们调查处理;
  • 针对问题请说明是Online在线功能(需说明用的主题模板),还是生成的代码功能;
  • 描述过于简单或模糊,导致无法处理的,会被直接删掉;
@zhangdaiscott
Copy link
Member

不分页?

@915999136
Copy link
Author

是选择用户的控件加载用户信息时执行了查询所以用户

@zhangdaiscott
Copy link
Member

收录 ty

@zhangdaiscott
Copy link
Member

zhangdaiscott commented Nov 22, 2021

使用的是这个组件吗,经查用户查询是分页查的,是不是部门数据量过大导致?
QQ图片20211122152224

@915999136
Copy link
Author

从后台sql能看出,页面加载时就去取查询了所有用户信息,还没打开组件,就打开页面时就会等很久然后报错,删掉一半用户就能打开页面了,测试时oracle7万个用户

@tygithub1
Copy link

image
用户是分页查询的
左边部门树的加载是查询所有的数据,是不是你的部门也有很多,然后卡住了,
左边部门树 现已改成异步加载,等下个版本

@zhangdaiscott
Copy link
Member

已经处理,请更新代码

@915999136
Copy link
Author

915999136 commented Dec 6, 2021

image
为啥我这用户没分页......
初始化字段时查询了所用用户?

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants