Re: [firebird-support] MON$ATTACHMENT performance issue

2019-08-26 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] MON$ATTACHMENT performance issue

2019-08-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-08-26 14:36, Róbert Sisa robert.s...@dyntell.com [firebird-support] wrote: > 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

Re: [firebird-support] MON$ATTACHMENT performance issue

2019-08-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.08.2019 14:36, Róbert Sisa robert.s...@dyntell.com [firebird-support] wrote: > Can anybody help me?  It looks like a FB bug... No, this is not a bug. Yes, monitoring tables are slow and locking whole server to get snapshot of its state. Don't use them unless absolutely necessary. --

[firebird-support] MON$ATTACHMENT performance issue

2019-08-26 Thread Róbert Sisa robert.s...@dyntell.com [firebird-support]
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 So