-
Notifications
You must be signed in to change notification settings - Fork 580
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.
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
[feature] some optimization about Execute Script #1579
Comments
@scottsut so do you agree with me? will my code affect other functions |
@scottsut If it's ok, can you assigned this issue to me ? i want to do some contributors for datart. do I need permission to submit a PR? |
你使用的什么数据库?去掉这里的子查询仅仅只能在编写SQL的时候在某些数据库上提升响应速度。 在可视化图表的查询中子查询是无法去掉的。另外你说的 |
@tianlu-root 在可视化图表的确是无法解决。 业务场景(Business scene)
##改造后之后的sql (after change codes ) 我们也知道可视化图表中暂时无法解决,但是想在数据量大的情况下,数据视图模块能够响应,所以修改了这个代码. |
了解了。目前最新的代码(dev分支)对 |
你的功能要求与某个问题相关吗?
the interface path is “/data-provider/execute/test”
Data View Module
When I only use sql statement to query, and the data volume is several million, the backend execution is very slow and an error will be reported. It is found that a layer of temporary table DATART_VTABLE will be wrapped and then paginated
接口地址是 “/data-provider/execute/test”
数据视图模块
当我仅仅使用sql语句查询时,数据量几百万时,后端执行很慢,还会报错。发现会包一层临时表DATART_VTABLE 然后再分页
形容一下你想要的解决方案
When it is found that the front end only transmits sql statements, do not include a layer of temporary table DATART_VTABLE
当发现前端仅传sql时 不要包一层临时表DATART_VTABLE
描述一下你考虑过的备选方案
清晰简洁地描述任意你考虑过的备选方案和功能
其他内容
能帮忙看看会不会对其他功能有影响吗
Can you help to see if it will affect other functions?
It has been tested and seem like has no effect on the data view module. Modify the code as follows
已测试好像对数据视图模块无影响。修改代码如下
The text was updated successfully, but these errors were encountered: