Re: [firebird-support] RE: very slow inserts with blob-fields
On Wed, 2014-03-05 at 22:40 -0800, ma_go...@yahoo.com wrote: Hi! Firebird do not like ext4 FS. You must chane some settings. http://www.firebirdnews.org/?p=6421 Thanks for the tip. Remounting my ext4 partition with barrier=0 increased the write speed from ~8 rows/sec to 450 rows/sec. Yeay. There are a bewildering array of linux filesystem options I could look at tuning further. Can anyone recommend a good combination (ext3 vs ext4,xfs,btrfs with options writeback-vs-ordered, barriers etc.) for a firebird database. I can afford to lose a few seconds of data in the event of a hard crash, but the filesystem/database as whole needs to remain consistent. Thanks, Bryan
Re: [firebird-support] RE: very slow inserts with blob-fields
Em 6/3/2014 07:06, Bryan Cole escreveu: On Wed, 2014-03-05 at 22:40 -0800, ma_go...@yahoo.com wrote: Hi! Firebird do not like ext4 FS. You must chane some settings. http://www.firebirdnews.org/?p=6421 Thanks for the tip. Remounting my ext4 partition with barrier=0 increased the write speed from ~8 rows/sec to 450 rows/sec. Yeay. There are a bewildering array of linux filesystem options I could look at tuning further. Can anyone recommend a good combination (ext3 vs ext4,xfs,btrfs with options writeback-vs-ordered, barriers etc.) for a firebird database. I can afford to lose a few seconds of data in the event of a hard crash, but the filesystem/database as whole needs to remain consistent. Thanks, Bryan This is something I don't master and I really like to know about it... If someone has numbers or information about this I would love to know.
Re: [firebird-support] RE: very slow inserts with blob-fields
Re: [firebird-support] RE: very slow inserts with blob-fields
[firebird-support] RE: very slow inserts with blob-fields
Hi! Firebird do not like ext4 FS. You must chane some settings. http://www.firebirdnews.org/?p=6421 http://www.firebirdnews.org/?p=6421