Issue Details (XML | Word | Printable)

Key: DNET-868
Type: New Feature New Feature
Status: Closed Closed
Resolution: Won't Fix
Priority: Minor Minor
Assignee: Jiri Cincura
Reporter: Alan Usiadek
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
.NET Data provider

retrieve Non-Indexed and Indexed reads count of executed query for performance analysis

Created: 05/Feb/19 01:16 PM   Updated: 01/Aug/19 09:28 AM
Component/s: ADO.NET Provider
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jiri Cincura added a comment - 01/Aug/19 09:28 AM
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.