Request execution time jumps about superset HOT 1 OPEN

@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.

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 ^[1].

2. Database Load: The database might be under heavy load, causing fluctuations in query execution time. Running too many queries simultaneously can impact performance ^[1].

3. Soft Time Limit Exceeded: If a query exceeds a predefined time limit, it might be terminated, contributing to execution time variability ^[1].

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 ^[1].

These factors combined can lead to significant fluctuations in the execution time for a request, even when the query is limited to 100 results.

To continue talking to Dosu, mention @dosu.

from superset.