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-automations opened this issue Feb 5, 2019 · 4 comments

Comments

@firebird-automations
Copy link

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-automations
Copy link
Author

Modified by: @cincuranet

Fix Version: 7.0.0.0 [ 10912 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

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

@firebird-automations
Copy link
Author

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-automations
Copy link
Author

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
Development

No branches or pull requests

2 participants