Subject | Slow read performance when firebird is writing |
---|---|
Author | diwic2 |
Post date | 2005-06-22T12:08:57Z |
Hello. We have a server with a RAID 0+1 configuration. On this disk
there are a firebird database and some log files (among other things,
such as the operating system). It also has enough RAM to keep the
entire database in OS system cache.
The firebird database is rather write intensive with perhaps 1-10
transactions per second, and they often involve database updates.
Forced writes are on for safety reasons.
However, sometimes we want to read an old log file that is 30 MB. It
takes over 3 minutes to copy it to another machine, open it in
notepad, or whatever needed to read the file physically from disk.
(The second time, when the same file is in the W2k system cache, there
are no speed problems.)
Are there settings that I can make to make Firebird (1.5.2) less write
intensive, without losing any safety? Or an OS setting (Windows 2000
server) that makes the disk be a little more friendly to the
application that tries to read the log file, instead of giving
Firebird constantly 99% of the disk time?
(To insert more disks into the machine is not currently an option.)
Thankful for help!
// David
there are a firebird database and some log files (among other things,
such as the operating system). It also has enough RAM to keep the
entire database in OS system cache.
The firebird database is rather write intensive with perhaps 1-10
transactions per second, and they often involve database updates.
Forced writes are on for safety reasons.
However, sometimes we want to read an old log file that is 30 MB. It
takes over 3 minutes to copy it to another machine, open it in
notepad, or whatever needed to read the file physically from disk.
(The second time, when the same file is in the W2k system cache, there
are no speed problems.)
Are there settings that I can make to make Firebird (1.5.2) less write
intensive, without losing any safety? Or an OS setting (Windows 2000
server) that makes the disk be a little more friendly to the
application that tries to read the log file, instead of giving
Firebird constantly 99% of the disk time?
(To insert more disks into the machine is not currently an option.)
Thankful for help!
// David