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