Subject Re: [ib-support] Interbase/Firebird memory question
Author Alessandro
the difference in the worst case is of about 1000 transaction . Anyway i
sweep periodically the database without heavy result in memory decrease.


"Svein Erling Tysvaer" <svein.erling.tysvaer@...> wrote in
message news:[]...
> I cannot help you with your calculations, but would recommend you to start
> by checking the Oldest Active Transaction (OAT) and the Next Transaction.
> If the gap between these two numbers is big, you have a problem with an
> uncommitted transaction (and uncommitted transactions means that the
> database may have to store lots of old versions of records).
> HTH,
> Set
> At 10:29 27.02.2003 +0100, you wrote:
> >Hi,
> > presently i'm using Interbase 6 Open Source and i'm testing Firebird
> >for the migration. The databases engine (IB6) is installed on a RedHat
> >server machine.
> >When the engine start it takes about 18 Mbyte and 4 processes. Then i
> >some application that use 2 different mono-file databases of maximum 10
> >Mbyte size. With about 3 simultaneous connection on the first database
and 5
> >on the second one my interbase size reach after some days about 120 Mbyte
> >memory with about 8 processes and keep on increasing.
> >In order to understand if it's a bug in application or an IB normal
> >behaviour i need to make me an idea on how to evaluate the maximum size
> >such database might reach in memory related to the maximum number of
> >connections,the database file size and the IB sever configuration params.
> >Anyone can help me to find out a method or an explaining document to
> >this memory evaluation problem ?
> >Thanks for any suggestion.
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to