Subject Re: [firebird-support] MON$ATTACHMENT performance issue
Author Carlos H. Cantu
Post date 2019-08-26T15:02:52Z
Re: [firebird-support] MON$ATTACHMENT performance issue Keep in mind that when you access a monitoring table, Firebird takes a "snapshot" of the whole server "status" at that moment.

So, even when you are accessing just mon$attachments, FB needs to create snapshot with data for all the monitoring tables, to offer you a consistent view among them. This is not a cheap operation.

Carlos
Migration Guide to Firebird 3
https://www.firebirdnews.org/migration-guide-to-firebird-3/


Hi All,

I have a problem with Firebird 3.0.4. When i run this query:

SELECT 0 FROM MON$ATTACHMENTS

the result set contains 94 records and it run for 1.2 second. It cause performance problems in my program.

Can anybody help me?  It looks like a FB bug...
--
Üdvözlettel,

Sisa Róbert - Dyntell Software
Vezető fejlesztő
Mobil: +36 (70) 417-7332 | Fax: +36 (52) 998-021
Email: robert.sisa@... | Web: www.dyntell.com