Btrfs Mount Option Benchmarks With The Linux 4.9 Kernel
With the SQLite embedded database workload, disabling the tree logging reduced performance. Improving the performance the most was nobarrier for disabling device barriers, which is unsafe if your system experiences power failure.
For random writes with FIO, discard helped the performance while especially the disabling of the CoW data really boosted the performance.
Discard helped out in sequential reads via FIO.
Disabling the copy-on-write really boosted the performance of Btrfs for FIO sequential writes, but then again disabling CoW for Btrfs defeats much the purpose of Btrfs.