And cofiure the CpuAffinity param located in firebird.conf



On Tue, Sep 20, 2011 at 12:19 AM, Ricardo Uzcategui
<ricardouven@...>wrote:

> if you want to risk your data, use RAMDISK.. but, it's come so fast our
> querys...
>
> http://www.softperfect.com/products/ramdisk/
>
> Remember.. use the shadow to ensure your data will be safe..
>
>
>
> On Mon, Sep 19, 2011 at 8:12 PM, Leyne, Sean <Sean@...>wrote:
>
>> **
>>
>>
>> Marcelo,
>>
>>
>> > I have a Firebird 2.5 server running in a Windows Server 2008 64bit. The
>> > server have 16 cpu cores and 16GB of RAM. The database file have 3099MB
>> > of size and I have 2% of writes against 98% of reads of all I/O
>> requisitions.
>> > How can I put the entire database (or the most part) in memory by
>> adjusting
>> > the Page Size, Cache Size and the DefaultDbCachePages parameter? Is it
>> > possible?
>>
>> Over time the Windows OS will effectively have the entire database in its
>> page cache, so I don't think there is anything you really need to do.
>>
>> Sean
>>
>>
>>
>
>
>
> --
> Ricardo...
>

--
Ricardo...


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