| Subject | Re: [firebird-support] Re: Automatic Firing of Query. |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2017-08-17T11:40:27Z |
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 sd@... [firebird-support] <firebird-support@yahoogroups.com>:
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.
------------------------------ ------
------------------------------ ------
++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++
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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-digest@ yahoogroups.com
firebird-support-fullfeatured@ yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@ yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/ us/yahoo/utos/terms/