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 (6 days ago)

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 (6 days ago)

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 (6 days ago)

*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 (6 days ago)

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 (5 days ago)

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 (4 days ago)

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 (4 days ago)

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.