Uwe Grauer wrote:

> Chris M wrote:
>
>
>>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*
>
>
> This looks good.
> You should test your Udf's now.
>
> Uwe

I don't use any UDFs