--- In firebird-support@yahoogroups.com, "xuxu" <xufh@c...> wrote:

>
> firebird-support£¡
> My firebird will become slowly after about 4 hours hard working .
> ( 4000 reads/hour, 4000 update/hour, 2000 insert/hour )
> I can find this in /opt/firebird/firebird.log :
> -------------------------------------------------------------------
> localhost.localdomain (Server) Thu Oct 20 12:11:06 2005
> Database: /opt/interbase/data/AccountData.gdb
> internal gds software consistency check (Too many savepoints (287))
> -------------------------------------------------------------------
> I will show u the DB info:
> -----------------------------------------------------------------------
> Database "/opt/interbase/data/AccountData.gdb"
>
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 497561
> Page size 4096
> ODS version 10.1
> Oldest transaction 496725
> Oldest active 496726
> Oldest snapshot 496726
> Next transaction 497552
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 19
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Jun 4, 2004 9:44:42
> Attributes
>
> Variable header data:
> Sweep interval: 0
> *END*
>
> -rw-r--r-- 1 root root 309435904 Oct 20 01:02 AccountData.gbk
> -rw------- 1 root root 549576704 Oct 20 17:29

AccountData.gdb

>
>
>

-------------------------------------------------------------------------------------

> What is the probably reason ?
>

You have 826 uncommitted transactions.
Maybe that's the problem

Mick