cookieY
[Question] 查询页面select无响应
描述问题 执行select * from t where column in(,,,,,,)这样的sql，当in的个数很多，比如7000个数值，会导致页面无响应， yearning日志报错如下： [Error] 2023-11-09 20:24:08 (Yearning-go/src/handler/personal/query.go:184) unexpected EOF
复现 重现该行为的步骤:
- 查询页面执行select * from t where column in(,,,,,,)类似的sql，in的数值个数在7000个左右；
- 页面无响应
- yearning日志报错如下： [Error] 2023-11-09 20:24:08 (Yearning-go/src/handler/personal/query.go:184) unexpected EOF
当前使用版本：3.1.6.3
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Title: [Question] Query page select does not respond
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Returning a large amount of data will cause the page to go OOM and then become unresponsive. There is currently no particularly good solution to this problem.
大量数据返回会把页面搞的oom 然后未响应，这个目前还没有特别好的解决思路
当前页面查询完后间隔几分钟在查询的时候就一直转圈圈， 要强刷下页面才可以。 这个是websocket的问题吗， 有解吗
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Returning a large amount of data will cause the page to go OOM and then become unresponsive. There is currently no particularly good solution to this problem.
After the current page is queried, it will keep spinning in circles for a few minutes during the query. You have to forcefully refresh the page. Is this a websocket problem? Is there any solution?