Since the query contains 'from RDB$RELATION_FIELDS R, RDB$FIELDS F where ... R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-89 type of JOIN) and not 'from RDB$RELATION_FIELDS R JOIN RDB$FIELDS F ON R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-92 type of JOIN), I would be surprised if database access library.
When the slow query is executing, try running something like: SELECT a.*, s.MON$SQL_TEXT FROM MON$STATEMENTS s JOIN MON$ATTACHMENTS a ON s.MON$ATTACHMENT_ID = a.MON$ATTACHMENT_ID WHERE s.SQL_TEXT CONTAINING 'from RDB$RELATION_FIELDS R, RDB$FIELDS F where' Then I hope MON$USER will return the user name of the person that sent this query, MON$REMOTE_ADDRESS the IP address (or similar) and MON$REMOTE_PROCESS the name of the program that fired it. HTH, Set 2017-08-17 11:36 GMT+02:00 Dimitry Sibiryakov [email protected] [firebird-support] <[email protected]>: > 17.08.2017 11:32, [email protected] [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. > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at http://www.ibphoenix.com/ > resources/documents/ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > >
