Skip to Content (Press Enter)
Back to Ideas
29
Like
Follow Idea
Show SQL Test execution time
1070Views
8Comments
New
Backend

It would be interesting to show the execution time of the query when pressing the "Test" button in the SQL Editor for advanced queries.

Yes, it's not a real view of how the query is doing, but it may help in understanding if a query is REALLY slow, or slightly slow.

04 Apr 2018
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha
Changed the category to
Backend
05 Apr 2018
Copy link to comment

Hi Paulo,

Do you think this is relevant? Thinking that in most of the cases you don't have real data on DEV environments, therefore you may have very different execution times between environments DEV and PROD.

I understand the need but I would say you can get very misleading values. And in some cases you may think that your query is very performance but when you deploy to PROD is not has performance. 

Let me know your thoughts on this, from your experience how many projects you had production like data on development environment so that execution time can be compared.


Thanks,



15 Nov 2018
Copy link to comment

Hi, I was going to upload an Idea somewhat like this. 


My use case is a project for banks that is getting refactored and a lot of the logic and queries are getting refactored to have a better performance.  

This would help because we could compare execution times and compare implementations as most people don't have access to the SQL server to check the execution plan.


 

09 Aug 2019
Copy link to comment
Merged this idea with 'Advanced Queries - Execution Time' (created on 29 May 2020 16:12:23 by Diana Milheiro)
15 Apr 2021
Copy link to comment

It would be very useful to have the execution time of a query when we "test" in the service studio.




This comment was:
- originally posted on idea 'Advanced Queries - Execution Time' (created on 29 May 2020 by Diana Milheiro)
- merged to idea 'Show SQL Test execution time' on 15 Apr 2021 05:41:32 by Daniël Kuhlmann
29 May 2020
Copy link to comment

Although it is useful information, the execution time of the same query in DEV can be totally different in PROD as the number of records to query is also an important factor in the performance. If seen it to many times that all performs well in DEV, and we get an unpleasant surprise in PROD. 



This comment was:
- originally posted on idea 'Advanced Queries - Execution Time' (created on 29 May 2020 by Diana Milheiro)
- merged to idea 'Show SQL Test execution time' on 15 Apr 2021 05:41:32 by Daniël Kuhlmann
15 Apr 2021
Copy link to comment

Hi Daniel,


In some customers we have the same volume in QA environments as we have in Production, so it is beneficial to have this information. We can also detect problems connecting to the Database server.


Kind Regards,

Diana Milheiro

15 Apr 2021
Copy link to comment

This is a great idea! We have several customers with the same volume of production data, so this would help us identifying some issues!

15 Apr 2021
Copy link to comment