Re: [Firebird-devel] Query statistics

2019-08-02 Thread Dmitry Yemanov
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

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Leyne, Sean
> >>> 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

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Vlad Khorsun
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

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Leyne, Sean
> > 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

Re: [Firebird-devel] (no subject)

2019-08-02 Thread Mark Rotteveel
On 31-7-2019 20:42, levi miller wrote: How do I find the server name for fleet manager network edition You should ask the support team of the company that wrote Fleet Manager (whatever that is), or possibly the system administrator of your company. Mark -- Mark Rotteveel Firebird-Devel mai

[Firebird-devel] [FB-Tracker] Reopened: (CORE-6114) isc_open_blob2 fails when selecting blob field from view with "no permission for SELECT access to TABLE X" error.

2019-08-02 Thread Sean Leyne (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-6114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Leyne reopened CORE-6114: -- > isc_open_blob2 fails when selecting blob field from view with "no permission > for SELECT access to TABL

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Vlad Khorsun
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

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Leyne, Sean
> 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

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Leyne, Sean
> >> 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

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Vlad Khorsun
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:

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Vlad Khorsun
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

[Firebird-devel] [FB-Tracker] Created: (CORE-6114) isc_open_blob2 fails when selecting blob field from view with "no permission for SELECT access to TABLE X" error.

2019-08-02 Thread Tom Devereux (JIRA)
isc_open_blob2 fails when selecting blob field from view with "no permission for SELECT access to TABLE X" error. - Key: CORE-6114 URL: http://tracker.