Subject RE: [firebird-support] Re: commit after insert is very slow (bis - new thread)
Author Slavomir Skopalik
Hi,
this is confirmed on WinXP 64 and Windows server 2003 64.

We uses this also on Windows server 2008 64.

To check, open Windows task manager, select Performance page and see
Physical memory.

There is info about System cache.
All our 64 server have disabled swap and working well (planing and
monitoring system
in factories) in 24x7 mode.

To test it, try to run DB restore for DB that is larger than your RAM and
time to time,
try to do somethig, you will se.

Slavek
Ing. Slavomir Skopalik
Jednatel spolecnosti
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
--------------------------------------------
Mobil: +420 724 207 851
icq:199 118 333
e-mail:skopalik@...
http://www.elektlabs.cz <http://www.elektlabs.cz/>






hmmm, that could be a VERY GOOD THING TO KNOW if we can definitively confirm
it (microsoft say to never disable the pagefile.sys so before to disable it
i want to be absolutely sure)

how to study the pagefile.sys (the memory file swap) activity to be
absolutely sure ? I have 32 GB of memory and 35GB for the pagefile.sys

thanks by advance
stephane

--- In firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com, "Slavomir Skopalik" <skopalik@...> wrote:
>
> Hi,
> on Windows, mainly on Win64 we have this experience:
> OS are trying to do best posible file caching and putting FB cache into
swap
> file.
> This typically starting when DB size is over ~80% of RAM.
> Our final solution was simple, we was disable swap.
>
> This solution radicaly improove system reaction time.
> We don't receive any problem with memory (all machone has more then 8GB
> RAM).
>
> This mean, try to look how many RAM is used for file caching.
>
>



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