Thomas, > >>> I am also very skeptical about the "need" that to add this > >>> functionality to > >> the Trace API, as it falls into the area of PSQL debugging/profiling > >> which is not what the current functionality is about*. > >> > >> I don't propose to extend the Trace API in a way, which goes into > >> debuging a stored procedure with all that stuff like local variable values > etc. > >> > >> IMHO this should be part of a separate Debug API, which AFAIK has > >> been discussed in the past to expose something more reliable to > >> third-party developer tools like Database Workbench, IBExpert ... > >> than what they currently try to "simulate". > > > > I am happy that you agree with the general functional boundaries. > > > > > >> For databases, which are very PSQL-centric, which have a lot of > >> business logic implemented in PSQL, the Trace API is not of that much > >> use today, > >> because: > >> > >> * No I/O statistics for procedure/trigger trace events. According to > >> Vlad, it should be available, he has a look on that > > > > I agree that this is a problem. > ... > So, a mix of DML inside the SP and a call of another SP. > > > * SP gets executed via: > > execute procedure P_ENDLESSLOOP(2); > > > In this example, we get the following trace output:
> Hmm, see above. :-) IMHO, it would add value already at Trace output > level to focus/pin-point a problem for forthcoming debugging tasks more > easily. IMHO, the fact that the master SP runs slowly/poorly is what a Trace API/tool should highlight. Getting into the performance within an SP is the role of a debugger/profiler. The Trace API is about getting high level details, finding the "worse offenders" so that developers can spend their limited time to the maximum benefit. It is not about measuring each single operation. The answer to whether something should be done is not only about whether there is "added value" to the feature, it is also about "the cost". Adding more details to the trace output has a cost -- in the overhead in collecting the stats/information, in the increased disk IO that more stats would generate and in the time required to parse/analyze the increased data. Sean ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
