Add trace info about read query in packets
------------------------------------------
Key: CORE-6456
URL: http://tracker.firebirdsql.org/browse/CORE-6456
Project: Firebird Core
Issue Type: New Feature
Components: Engine, TRACEMGR
Reporter: Karol Bieniaszewski
Provide the way to see info about packet read in trace.
I mean e.g.:
Table have 10000 records.
I do SELECT * FROM MY_TABLE
But i do not read all records at start (do not fetch all) but i read data in
packets e.g. 300 records at one time.
Such statement is shown in MON$STATEMENTS as „Stalled".
Now i do not see any info in trace about this fetches.
I see only PREPARE_STATEMENT, EXECUTE_STATEMENT_START, CLOSE_CURSOR,
EXECUTE_STATEMENT_FINISH, FREE_STATEMENT
But i need to calculate how long query was executed.
And between next 300 record fetches can be e.g. 5 minute break.
And i report then such query in my tool as long long running query which
consume resources continously.
But really this query run only few ms. All fetches alltogether take e.g. 100ms
but i report it as they run e.g. 1 hour.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
