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.