Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

retrieve Non-Indexed and Indexed reads count of executed query for performance analysis [DNET868] #799

Closed
firebird-issue-importer opened this issue Feb 5, 2019 · 4 comments

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Feb 5, 2019

Submitted by: Alan Usiadek (alanu4080)

It would be nice to have a possiblity to retrieve some additional informations of executed query (Tools like IBExpert can do this):
- Non-indexed reads count
- Indexed reads count

other useful informations are (a little bit more than affected recors count):
- updates count
- deletes count
- inserts count

with those it would be possible to monitor queries running in our programs and log if they have any non-indexed reads, and maybe they need some rewriting.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 26, 2019

Modified by: @cincuranet

Fix Version: 7.0.0.0 [ 10912 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 30, 2019

Modified by: @cincuranet

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 1, 2019

Commented by: @cincuranet

This is already possible using FbDatabaseInfo class. But these values are accumulated per attachment/connection, hence one needs to take reading before and after and compute the difference.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 1, 2019

Modified by: @cincuranet

status: In Progress [ 3 ] => Closed [ 6 ]

resolution: Won't Fix [ 2 ]

Fix Version: 7.0.0.0 [ 10912 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants