Query Elapsed Time

By Carlos Henriques on 7 Oct 2015
It would be great if both Aggregate and SQL widgets could show the elapsed time of a query in the output window.

It would be very helpful to see execution time when testing a query, especially if you are experiencing performance issues.



Merged from 'Get currect query execution time on test SQL' (idea created on 2017-02-14 10:14:47 by João Inácio), on 2017-02-15 10:31:57 by André Vieira

The same has:


http://www.outsystems.com/ideas/2182/query-elapsed-time



Merged from 'Get currect query execution time on test SQL' (idea created on 2017-02-14 10:14:47 by João Inácio), on 2017-02-15 10:31:57 by André Vieira

*as



Merged from 'Get currect query execution time on test SQL' (idea created on 2017-02-14 10:14:47 by João Inácio), on 2017-02-15 10:31:57 by André Vieira

Right!



Merged from 'Get currect query execution time on test SQL' (idea created on 2017-02-14 10:14:47 by João Inácio), on 2017-02-15 10:31:57 by André Vieira
J.15 Feb

I am not sure if it would help much.


perhaps to test different queries, yes, but you are lacking caching, execution plans etc. which are more useful during runtime stuff, where queries are ran often.


Imagine the following, you are testing a query and it takes about 2 seconds to give results and then you modify it to have more performance you test it and then it takes about 2 seconds but in reality is latency communication that is deceiving you, because you don't have a clue how many seconds the Database took to performance that query.

J.16 Feb

Well I understand that, but the variables are different.

you are testing via SS and directly via the platform under a user.

this is not equivalent to running those queries via the website, especially perfomance-improvement are taken into account on screenactions and such.