02.08.2019 17:28, Vlad Khorsun wrote:
I was hoping to gather those details via MON$ tables.
It is present in MON$RECORD_STATS and MON$TABLE_STATS (since FB4)
Since FB3, actually ;-)
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebi
> >>> I was hoping to gather those details via MON$ tables.
> >>
> >> It is present in MON$RECORD_STATS and MON$TABLE_STATS (since FB4)
> >
> > Am running v2.5.x
>
>Hope, you have one more argument to try FB4 ;)
The issue is not philosophical, rather it is "physical".
We have over 8
02.08.2019 19:31, Leyne, Sean wrote:
I was hoping to gather those details via MON$ tables.
It is present in MON$RECORD_STATS and MON$TABLE_STATS (since FB4)
Am running v2.5.x
Hope, you have one more argument to try FB4 ;)
I have a DB SP which itself calls several SPs, and I was h
> > I was hoping to gather those details via MON$ tables.
>
>It is present in MON$RECORD_STATS and MON$TABLE_STATS (since FB4)
Am running v2.5.x
> > I have a DB SP which itself calls several SPs, and I was hoping to collect
> > details
> on the operations that each child SP performs (in
02.08.2019 17:16, Leyne, Sean wrote:
Sean,
How can those stats be related to the *tables* on which the activity is
performed against?
Below is excerpt from APU Guide, if your question was about something else -
please, clarify:
---
Database operation counts
Several infor
> Sean,
>
> > How can those stats be related to the *tables* on which the activity is
> performed against?
>
>Below is excerpt from APU Guide, if your question was about something else
> -
> please, clarify:
>
> ---
>Database operation counts
>
>Several information items are
> >> More details is available at API Guide, see "Database operation
> >> counts" at chapter 4 "WORKING WITH DATABASES".
> >
> > Please provide link to the API Guide, went to the project site and was
> > unable to
> find the doc.
>
>Links to all IB6 docs are placed here:
>
> https://fireb
02.08.2019 8:25, Leyne, Sean wrote:
More details is available at API Guide, see "Database operation counts" at
chapter 4 "WORKING WITH DATABASES".
Please provide link to the API Guide, went to the project site and was unable
to find the doc.
Links to all IB6 docs are placed here:
https:
01.08.2019 16:45, Leyne, Sean wrote:
Sean,
How can those stats be related to the *tables* on which the activity is
performed against?
Below is excerpt from APU Guide, if your question was about something else -
please, clarify:
---
Database operation counts
Several information it
> More details is available at API Guide, see "Database operation counts" at
> chapter 4 "WORKING WITH DATABASES".
Please provide link to the API Guide, went to the project site and was unable
to find the doc.
Sean
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
Vlad,
How can those stats be related to the *tables* on which the activity is
performed against?
Sean
> -Original Message-
> From: Vlad Khorsun
> Sent: Thursday, August 1, 2019 5:15 AM
> To: firebird-devel@lists.sourceforge.net
> Subject: Re: [Firebird-devel] Q
> There's also the isc_dsql_sql_info() API call (see chapter 6 of the API
> Guide). This gives statistics on a per SQL statement basis, and allows
> you to get the number of inserts, updates, deletes, etc. performed by
> the statement. Note that in the Firebird 3 API this is implemented as
> th
There's also the isc_dsql_sql_info() API call (see chapter 6 of the API
Guide). This gives statistics on a per SQL statement basis, and allows
you to get the number of inserts, updates, deletes, etc. performed by
the statement. Note that in the Firebird 3 API this is implemented as
the IStateme
>These stats counters are available at the attachment level. See
> isc_database_info() and tags below:
Thanks. That's already in provider. I suppose the two readings required are not
the end of the world.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list,
31.07.2019 15:06, Jiří Činčura wrote:
Hi *,
is it possible to get statistics about the executed query similar to what
isc_info_req_insert_count etc. allows? I'm mostly interested in
indexed/non-indexed read counts, but whetever is available I'll include in the
implementation.
These stats
15 matches
Mail list logo
