| Subject | Negative impact on system performance querying monitoring tables. |
|---|---|
| Author | Marcelo Guimaraes |
| Post date | 2019-10-04T12:01:37Z |
Hello everyone!
Reading about FB performance, I hit this page: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-appx05-montables.html
My surprise on the note was the warning: "In a highly loaded environment, collecting information via the monitoring tables could have a negative impact on system performance."
To administer a database and monitore his health usually we need to query monitoring tables (dictionary views). On FB, according to the doc, we have a negative impact on system performance, so how can we by pass that?
Was this issue solved on FB 3?
Regards,
Marcelo Guimarães
Reading about FB performance, I hit this page: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-appx05-montables.html
My surprise on the note was the warning: "In a highly loaded environment, collecting information via the monitoring tables could have a negative impact on system performance."
To administer a database and monitore his health usually we need to query monitoring tables (dictionary views). On FB, according to the doc, we have a negative impact on system performance, so how can we by pass that?
Was this issue solved on FB 3?
Regards,
Marcelo Guimarães