i noticed that the application opens several transactions (about 250) for small amount of data (tables that contains less than 20 rows). is this amount of open transactions (which are never commited while the application is running) a cause for the ibserver to start working slowly after a couple of hours?

----- Original Message -----
From: Ann W. Harrison
To: ib-support@yahoogroups.com ; ib-support@yahoogroups.com
Sent: Wednesday, December 05, 2001 4:33 PM
Subject: Re: [ib-support] IB server doesn't free memmory and my application turns extremely slow


At 02:33 PM 12/5/2001 -0300, Luciano Sparacino wrote:

> the ibserver, which is running on a winnt 4.0, keeps increasing the
> amount of allocated memmory up to a point in which it works very slow for
> operations that are usually done in a snap.

Are you using commit retaining? How many records do you insert
in each transaction?

> I'd like to know if there's any configuration that i should try or,
> since i read that several people noticed that the win32 version doesn't
> free memmory, if IB server for linux has the same problem.

Firebird doesn't release memory, but both it and InterBase should reuse
memory.


Regards,

Ann
www.ibphoenix.com
We have answers.


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]