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..
It's a kind of myth - shadow will not help a lot.
Try to push RESET under load in RAMDisk+shadow
On Mon, Sep 19, 2011 at 10:41 AM, Marcelo Caetano marc...@optotal.com.brwrote:
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
On Tue, Sep 20, 2011 at 10:17 AM, Alexey Kovyazin a...@ib-aid.com wrote:
Ann,
...
By allocating that much memory to the database page cache, you reduce the
amount of memory available for other uses, like the system page cache.
if Marcelo wants to achieve better performance, not just put
-Original Message-
From: Ann Harrison
Sent: 20. september 2011 17:44
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to put an entire Database in memory using
cache?
On Tue, Sep 20, 2011 at 10:17 AM, Alexey Kovyazin a...@ib-aid.com wrote:
Ann,
...
By
Thank you very much for your advice, Ann, I'll remember that.
Greetings.
Walter.
On Tue, Sep 20, 2011 at 11:44 AM, Ann Harrison aharri...@ibphoenix.comwrote:
**
On Tue, Sep 20, 2011 at 10:17 AM, Alexey Kovyazin a...@ib-aid.com wrote:
Ann,
...
By allocating that much memory to
Sure... Super Clasic is the best for this smf/multiclient work...
On Tue, Sep 20, 2011 at 1:02 AM, Dmitry Kuzmenko k...@ibase.ru wrote:
**
Hello, Ricardo!
Tuesday, September 20, 2011, 8:50:08 AM, you wrote:
RU And cofiure the CpuAffinity param located in firebird.conf
CpuAffinity can
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
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 s...@broadviewsoftware.comwrote:
**
Marcelo,
I have