Accessing server info anprofiler info for InterBase/Firebird

upscene · Post by **upscene** » Wed 25 Nov 2009 10:02

Hi,

Is it possible to access statistics info for InterBase/Firebird?

And how can I get access to server specific info, can I use the API directly somehow?

With regards,

Martijn Tonies
Upscene Productions

Plash · Post by **Plash** » Thu 26 Nov 2009 09:03

UniDAC does not have features for accessing the server info and statistics.

upscene · Post by **upscene** » Thu 26 Nov 2009 09:12

Actually, I was thinking of statement statistics, indexed reads and so on.

If this isn't available, does IBDac have it? (although I purchased UniDac already

)

Plash · Post by **Plash** » Thu 26 Nov 2009 13:39

IBDAC has the TIBCStatisticsService component. You can use it to get statistics.

upscene · Post by **upscene** » Thu 26 Nov 2009 13:45

Plash wrote:IBDAC has the TIBCStatisticsService component. You can use it to get statistics.

That components gets -database- statistics, not statement statistics.

Have a look at the IBObjects TIB_Profiler component to see what I mean.

upscene · Post by **upscene** » Thu 26 Nov 2009 13:51

upscene wrote:
Plash wrote:IBDAC has the TIBCStatisticsService component. You can use it to get statistics.
That components gets -database- statistics, not statement statistics.

Have a look at the IBObjects TIB_Profiler component to see what I mean.

PS: I'm currently evaluating IBDac as well, I might use both after all...

Plash · Post by **Plash** » Wed 02 Dec 2009 10:55

The DatabaseInfo property of TIBCConnection is an analog of TIB_Profiler.