> gstat output (normal performance):
> ---------------------------------------------------------

>  Oldest transaction 18709808
>  Oldest active  18953295
>  Oldest snapshot  18851591
>  Next transaction 19520857

The large difference in Oldest Active and Next Transaction suggests that your 
problem is with garbage collection which is creating a growing backlog of pages 
that need to be read to find the correct record versions.

You have a process which is not committing transactions which you need to find, 
using the MON$Transactions and MON$Attachments tables.


Sean

  • ... conver...@gmail.com [firebird-support]
    • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
      • ... conver...@gmail.com [firebird-support]
        • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
        • ... Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
          • ... Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
          • ... conver...@gmail.com [firebird-support]
            • ... Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
              • ... conver...@gmail.com [firebird-support]
                • ... Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
        • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
          • ... conver...@gmail.com [firebird-support]
            • ... Alexey Kovyazin a...@ib-aid.com [firebird-support]

Reply via email to