Page 1 of 1

Statement statistics

Posted: Mon 30 Nov 2009 10:00
by upscene
Hi,

In the UniDac forum I asked about statement statistics (not DB statistics via the Services API).

It seems a matter of being able to refresh DatabaseInfo on the TIBCConnection component with a call to isc_database_info, would you be able to do that? (adding a Refresh method or something?)

With regards,

Martijn Tonies
Upscene Productions

Posted: Wed 02 Dec 2009 10:09
by Plash
TIBCConnection does not cache DatabaseInfo. It queries the info each time using API functions. Probably database information is cached inside the client library.

Posted: Wed 02 Dec 2009 10:16
by upscene
Plash wrote:TIBCConnection does not cache DatabaseInfo. It queries the info each time using API functions. Probably database information is cached inside the client library.
Can you clarify "each time"?

Whenever I access a property of DatabaseInfo?

Cause that would mess up the statistics as well.

Posted: Thu 03 Dec 2009 12:33
by Plash
The API function is called each time when you access a specific property of DatabaseInfo. This should not cause any problems.

Posted: Fri 04 Dec 2009 09:27
by upscene
Plash wrote:The API function is called each time when you access a specific property of DatabaseInfo. This should not cause any problems.
Right, I checked with the Firebird group about these values, they never get reset at the server, which is what I was thinking, so that cleared things up.

Thanks for the answers, I'll get going with this :)