Subject Re: firebird allocates suddenly a lot of m emory and causes XP to swap
Author Ali Gökçen
Michael,
can you report us your db stat using gstat?
(use gstat -? for options)
Your record length may be long because of 200 fields.
This needs 1-16 page writes for any insert/update.
what is your disc cluster(block) and fdb file page size?
if you did convert the disc from FATxx to NTFS, you will see it
becomes unproductive 512 bytes allways,
because clever M$ programmers knows fastest of algorithyms.

Ali

--- In firebird-support@yahoogroups.com, "Messner, Michael"
<Messner@...> wrote:
>
> 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/>
>