You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "KostyaRechkin (via GitHub)" <gi...@apache.org> on 2024/06/14 11:41:55 UTC
[I] Request execution time jumps [superset]
KostyaRechkin opened a new issue, #29252:
URL: https://github.com/apache/superset/issues/29252
### Bug description
Request execution time jumps
### How to reproduce the bug
Run long query 100
### Screenshots/recordings
### Superset version
master / latest-dev
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Request execution time jumps [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #29252:
URL: https://github.com/apache/superset/issues/29252#issuecomment-2167858030
<!-- Greeting -->
@KostyaRechkin Hello there! 👋 I'm here to help you with any bugs, questions, or contributions while you wait for a human maintainer. I'm Dosu, a bot who loves to squash bugs and assist users like you.
<!-- Answer -->
The execution time for a request can fluctuate significantly when running a long query with a limit of 100 due to several factors:
1. **Query Complexity**: Complex queries can take a long time to run, leading to significant fluctuations in execution time. If a query is too complex or the database is under heavy load, it might be killed after a certain time limit <sup>[[1]](https://github.com/apache/superset/blob/master/superset/sql_lab.py)</sup>.
2. **Database Load**: The database might be under heavy load, causing fluctuations in query execution time. Running too many queries simultaneously can impact performance <sup>[[1]](https://github.com/apache/superset/blob/master/superset/sql_lab.py)</sup>.
3. **Soft Time Limit Exceeded**: If a query exceeds a predefined time limit, it might be terminated, contributing to execution time variability <sup>[[1]](https://github.com/apache/superset/blob/master/superset/sql_lab.py)</sup>.
4. **Fetching Data**: The process of fetching data can introduce variability in execution time. The function handling the query fetches data and applies limits, which can affect the overall execution time <sup>[[1]](https://github.com/apache/superset/blob/master/superset/sql_lab.py)</sup>.
These factors combined can lead to significant fluctuations in the execution time for a request, even when the query is limited to 100 results.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Request execution time jumps [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #29252: Request execution time jumps
URL: https://github.com/apache/superset/issues/29252
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Request execution time jumps [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #29252:
URL: https://github.com/apache/superset/issues/29252#issuecomment-2744457554
Closing this as stale, but also since it's largely inactionable. I'm not sure what the symptom is, the description of the issue seems incomplete. If you're still facing this in 4.1.1 or newer, let us know a bit more context, and we can revisit/reopen.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org