Subject Re: 2nd: firebird sharing I/O with other programs
Author diwic2
> 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

Thanks for your answer. I'm still puzzled that it takes so long time
though. If the programs accessing the firebird database are offline,
reading the log takes about five seconds (6 MB/s), and when online
reading the log takes three minutes (0,2 MB/s. If the OS was a fair
guy, it would give 50% of the I/O time to firebird and 50% of the time
to reading the log file. But it seems like firebird gets 97% of the
physical disk time and reading the log file gets about 3%.

I know firebird uses some flags when writing to the disk, I think
write_through is one of them. Could that make the OS think that
firebird's writes are more important? (Perhaps this is a discussion
for firebird-devel?)

// David