Hi,

I can confirm that firebird is allocating the virtual memory. I can see that
in taskmanager. Firebird memory goes up and parallel I can see the pagefile
growing up to 1.5GB.
For sure I have a lot of record-versions, because I'm updating the same
record very often. But I thought the old versions get killed after a select,
that's why I tried to do a select every 100 updates.


mit freundlichen Grüssen

Michael Meßner
WAFIOS AG
Silberburgstrasse 5
D-72764 Reutlingen
Germany
Phone: +49/7121/146-491
Fax: +49/7121/491209
eMail: Messner@...
http://www.wafios.de <http://www.wafios.de/>

-----Ursprüngliche Nachricht-----
Von: Ali Gökçen [mailto:ali_gokcen@...]
Gesendet: Donnerstag, 9. März 2006 14:14
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Re: firebird allocates suddenly a lot of memory
and causes XP to swap


Hi,
can you confirm, that Virtual RAM allocated by Firebird exactly?
did you analysed Proccess/Thread, CPU, DISK I/O activities via the
Task Manager?
Is not it any side effect of any other program?
Whats is your disk definations?
if you have dupplicate indices and you will have alot of record
versions too because of sweep disabled. This cause preformance
disaster.

Ali

--- In firebird-support@yahoogroups.com, "michel_messner"
<Messner@...> wrote:

>
> Hi,
> I'm using firebird 1.5.2.4731 with a local connection. In my

database

> I have a quite big table with about 200 fields. There are not many
> rows in the table(200-2000). But I'm updating the same dataset very
> often. After 30000-50000 Updates Firebird starts to catch a lot of
> memory and causes Win XP Professional(SP2) to swap to the pagefile.
> During that 30-50seconds XP and Firebird is not responding anymore.
> What can I Do to prevent that.
> My transactions are very short and the logic is also ok.
> Sweep-interval is set to 0.
> I allready tried to do a select on that record every 100 updates,

but

> this didn't help.
> Sometimes when I validate the database with gfix there are many
> orphans in that table.
>
> Has someone a solution for that problem?
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net <http://firebird.sourceforge.net> and
click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com
<http://www.ibphoenix.com>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





SPONSORED LINKS
Technical support Computer technical support Compaq computer
technical support
Compaq technical support Hewlett packard technical support
Microsoft technical support

_____

YAHOO! GROUPS LINKS



* Visit your group " firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




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