Subject | Re: [firebird-support] RE: very slow inserts with blob-fields |
---|---|
Author | Alexandre Benson Smith |
Post date | 2014-03-06T20:36:46Z |
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...