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.
João Inácio14 Feb 2017

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
Carlos Henriques14 Feb 2017

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
Carlos Henriques14 Feb 2017

*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
João Inácio14 Feb 2017

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 2017

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.


João Inácio16 Feb 2017

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 2017

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.