0
 Followers
12
 Likes

Query Elapsed Time

Aggregates & Queries
On our radar
It would be great if both Aggregate and SQL widgets could show the elapsed time of a query in the output window.
Created on 7 Oct 2015
Comments (8)
Merged this idea with 'Get currect query execution time on test SQL' (created on 2017-02-14 10:14:47 by João Inácio)

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

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.

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.


views
135
Followers
0