Subject | Re: firebird allocates suddenly a lot of m emory and causes XP to swap |
---|---|
Author | Ali Gökçen |
Post date | 2006-03-09T14:18:22Z |
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:
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:
>can see that
> Hi,
>
> I can confirm that firebird is allocating the virtual memory. I
> in taskmanager. Firebird memory goes up and parallel I can see thepagefile
> growing up to 1.5GB.same
> For sure I have a lot of record-versions, because I'm updating the
> record very often. But I thought the old versions get killed aftera 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/>
>