Hi! #1 : FB does not like ext4 : Firebird News » Forced Writes Performance impact on #Ubuntu with ext4 no barrier http://www.firebirdnews.org/forced-writes-performance-impact-on-ubuntu/ http://www.firebirdnews.org/forced-writes-performance-impact-on-ubuntu/ Firebird News » Forced Writes Performance impact on #Ub... http://www.firebirdnews.org/forced-writes-performance-impact-on-ubuntu/ Tweet of the day comes from Carlos H. Cantu about forced writes effects for running firebird scripts Script executing time – Linux Ubuntu 10.04.3 Ext4 – ... View on www.firebirdnews.org http://www.firebirdnews.org/forced-writes-performance-impact-on-ubuntu/ Preview by Yahoo
#2 : HT is no necessary a good idea in case of data intensive applications (eg. databases) : Be aware: To Hyper or not to Hyper https://blogs.msdn.microsoft.com/slavao/2005/11/12/be-aware-to-hyper-or-not-to-hyper/ https://blogs.msdn.microsoft.com/slavao/2005/11/12/be-aware-to-hyper-or-not-to-hyper/ Be aware: To Hyper or not to Hyper https://blogs.msdn.microsoft.com/slavao/2005/11/12/be-aware-to-hyper-or-not-to-hyper/ Our customers observed very interesting behavior on high end Hyperthreading (HT) enabled hardware. They noticed that in some cases when high load is applied... View on blogs.msdn.microsof... https://blogs.msdn.microsoft.com/slavao/2005/11/12/be-aware-to-hyper-or-not-to-hyper/ Preview by Yahoo #3 : Use classic server, or superclassic (superserver does not like concurrency is a single database). #4 : I think the bottleneck here is the disk, not the engine itself. We made a test for bulk insert and best method was to run execute blocks with as many inserts as possible in it in a single thread. We achieved 8-9K records / sec for small tables and 3-4K records / sec for bigger tables. (tables were not indexed, and it was a simple HDD)
