Subject Re: [firebird-support] RE: very slow inserts with blob-fields
Author Carlos H. Cantu
Post date 2014-03-06T20:51:14Z
Re: [firebird-support] RE: very slow inserts with blob-fields Well, I would be interested in the results too, but I don't have too much hope that anyone here will be able to answer all those questions <g>

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br


Em 6/3/2014 16:46, Carlos H. Cantu escreveu:
Re: [firebird-support] RE: very slow inserts with blob-fields Firebird performance with forced-writes databases stored in linux partitions with Barrier parameter turned enabled is horrible for writings. You may not notice if you have slow volume of sporadic writings, but it becomes a real problem if you have "mass writings", like DML that will affect several records.

Solution is to disable FW or disable Barrier. So far, I really don't know what of this options would be better regarding "safety/stability".

[]s
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br

Yes...

But I am talking a bit wider question..

something like:
What's the diference (speed/security) between file systems (ext3, ext4, ReiserFS, etc)
What's the diference (speed/security) between journaling enable/disable
What's the diference (speed) for diferent sector/chunck sizes
What's the diference (speed) between  diferent RAID stripe size
.....

it's a really long answer I think... That demands a LOT of tests, that's the reason I had never conducted such expirement

:(

don't know if someone had gone trougth it...