Show Queries with long Execution Time

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Show Queries with long Execution Time

Postby gdurniak » Thu Aug 28, 2014 8:49 pm

In the 7.4.1 Performance Log, is there any way to show only the slowest queries ( with long execution times ) ?

greg
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA

Re: Show Queries with long Execution Time

Postby jcompagner » Tue Sep 02, 2014 9:55 am

define slowest?

i thought we previously had support that you could click on a header to sort by that header, that seems to be lost in the updates
(else you could just sort on avg end to end time)

Maybe you could make a case that you should be able to specify the sort column
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8833
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Show Queries with long Execution Time

Postby gdurniak » Wed Sep 03, 2014 5:52 pm

"slow" is relative, but usually in seconds

a sort, or filter, on Time would help e.g. show queries over 1 sec. duration

I did create a case

greg
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 5 guests