Interesting TDWI post

20/03/2009 10:07

The latest post on the TDWI site by Stephen Swoyer about bulk load performance contains several paragraphs written by Jos van Dongen based on his TPC-H SF100 load experiments. Please beware that there is one misquote in the article: Steve writes that OS DB's cannot load faster than 20-30 GB/Hr. This is not an absolute number and only correct considering the hardware mentioned. You can probably load > 100GB with a bunch of fast SSD or SAS disks in Raid 0 or 10 but it's beyond our budget to try out.