> Hello. I got no answer the previous time I posted this message, so
> I'll give it one more try.
>
> We have a server with a RAID 0+1 configuration. On this disk
> there is 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
>

FW On or FW Off are the only relvant settings here. You can also put a
middle tier in to consolidate transactions. Or you can rotate those logs a
little more intelligently and store them off the machine in question
Alan