A cool feature we'd like to see.

Classic Servoy
1

So, we’ve been trying to speed up our solution and we’ve been looking at the Performance Data on the server.

One thing that we thought is “Wouldn’t it be great if Server would allow us to name a find, relation or Aggregate so that when it pops up on the Performance Statistics on the app server, we’d know exactly what was causing that query.”

So, if we were doing a find in servoy, we could do this:

var searchName = 'Find Invoices'

if (forms.myform.controller.find())
{
invoice_id = arg0
var found = forms.myform.controller.search(true,false,searchName) 

}

And then when we looked at Performance Statistics… Servoy could add a column called “Name” and we could see how many times that search ran. And better, if it was slow, we could identify it quickly.

Obviously the server groups the queries by specific type, but it’s still always a bit of a hunt to find out where the query is being called. Wouldn’t this help?

Am I missing something?

2

Yes, it would be very nice.
I use this trick on all my custom sql queries: I always include a comment in it like this “SELECT … ORDER BY … – query comment here” so that I’m able to see it in the performance page and in the error log when debugging, I guess that something like this would be very quick to implement for Servoy guys and not too heavy on performance if the comment is kept short or truncated.