Chris M wrote:

> Uwe Grauer wrote:
>
>>Chris Meelhuysen wrote:
>>
>>
>>
>>>What types of things should i look for that could cause memory usage to
>>>go up and up on firebird 1.5.2 over each passing day so as a week later
>>>there is so much memory in use you cant shut down firebird and you have
>>>to kill it and reboot the server, etc.
>>
>>
>>Maybe an UDF with doesn't free its memory.
>>Do you have very long running transactions?
>>You really should hardcommit your work.
>>Show us your Statistics (gstat -h) please.
>>
>>Uwe
>>
>
>
> Its a customer's database I'm waiting to get a copy so I can get the
> statistics. But I can say I dont use any UDFs. Its a legacy app that
> was converted from paradox to interbase then firebird. I'm afraid that
> things aren't handled properly like commits etc. Its set to
> ReadRepeated right now if that answers anything.
>
>

Database Statistics

Database header page information:
Flags 0
Checksum 12345
Generation 998915
Page size 4096
ODS version 10.0
Oldest transaction 998870
Oldest active 998871
Oldest snapshot 998871
Next transaction 998872
Bumped transaction 1
Sequence number 0
Next attachment ID 39
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Feb 21, 2003 10:30:33
Attributes force write

Variable header data:
*END*