|Subject||Re: [firebird-support] MON$ATTACHMENT performance issue|
|Author||Carlos H. Cantu|
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.
Migration Guide to Firebird 3
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...
Sisa Róbert - Dyntell Software
Mobil: +36 (70) 417-7332 | Fax: +36 (52) 998-021
Email: robert.sisa@... | Web: www.dyntell.com