17.08.2017 11:32, anshuman.nanda@... [firebird-support] wrote:

> These queries are getting fired on its own even when there is no action taken in the
> system at a particular time interval. Not only that, these queries are getting fired
> even at the time when there are only select queries and no updates or insert are happening...

Run audit and see which connection/application it is run from. Then inspect sources of
that application and every library it uses to find the query and eliminate them.

> With my current usage, where the client is running in one geography and DB is in other, multiple calls of this query is creating a bottleneck when it comes to performance.

You can make your database distributed and provide a mirror near client to improve
performance.

--
WBR, SD.