Statement statistics

upscene · Post by **upscene** » Mon 30 Nov 2009 10:00

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

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

TIBCConnection does not cache DatabaseInfo. It queries the info each time using API functions. Probably database information is cached inside the client library.

upscene · Post by **upscene** » Wed 02 Dec 2009 10:16

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.

Plash · Post by **Plash** » Thu 03 Dec 2009 12:33

The API function is called each time when you access a specific property of DatabaseInfo. This should not cause any problems.

upscene · Post by **upscene** » Fri 04 Dec 2009 09:27

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