Adriano dos Santos Fernandes <adrian...@gmail.com> писал(а) в своём письме
Mon, 28 Sep 2020 03:11:05 +0300:
Hi!
Here is link to pull request, starting with the README describing the
feature:
https://github.com/FirebirdSQL/firebird/pull/285/files
I have a few questions.
1. Why is statistics limited to procedure / function / trigger and block
only? But what about queries and cursors inside blocks. Their execution
times are much more interesting.
2. The minimum and maximum time is certainly interesting, but it would be
nice to display the average execution time.
3. If tables RDB$PROFILE_SESSIONS, RDB$PROFILE_REQUESTS, RDB$PROFILE_STATS
read data only from memory, then why are they prefixed with RDB$, and not
MON$ for example?
I have a doubt about permissions.
If user can call procedure P1 but cannot himself call procedure P2, but
procedure P1 can call P2, if profiler should not collect data from P2.
Current it does.
The doubt is also about if execute or alter permissions should be
verified if that should not be allowed - remember we may be talking
about triggers too.
Adriano
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
--
Simonov Denis
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
