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 <http://www.firebirdnews.org>-
www.FireBase.com.br <http://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...
