I did some benchmarks with PTS SQLite-2.1.0 test with and without nocow as well as with and without Write-Ahead Logging.
The benchmarks show that by using Write-Ahead Logging, we can gain a 300% performance boost, compared to only about 25-30% using the nocow attribute. Not bad, huh?
I blogged about it here: https://wiki.tnonline.net/w/Blog/SQL...mance_on_Btrfs
EDIT: I did try to create a profile on openbechmarking.org, but the activation email doesn't work so I am stuck there Michael Can you help?
Announcement
Collapse
No announcement yet.
Fedora 33 To Be Released Next Week
Collapse
X
-
Phoronix, Linux Hardware Reviews, Linux hardware benchmarks, Linux server benchmarks, Linux benchmarking, Desktop Linux, Linux performance, Open Source graphics, Linux How To, Ubuntu benchmarks, Ubuntu hardware, Phoronix Test Suite
For those that think btrfs is a bad choice, those benchmarks show different.
Application start up would be much improved with BFQ scheduler though..
Also, if you enable WAL write ahead logging in sqlite, Btrfs becomes 3x faster!
Leave a comment:
-
Originally posted by Mario Junior View Post
Opensuse has the best btrfs implementation of all linux distros.
- Likes 2
Leave a comment:
-
Originally posted by Danniello View PostFor me btrfs is just great. You want to create "mistake protection" (snapshot: ) of 500GB catalogue with photos before starting some risky operation? Copy-paste in Nautilus - done in seconds.
Copy-On-Write is excellent idea
With btrfs is much easier to "protect" system before updates - I had couple situations that after `dnf update` in Fedora - something stopped working (problem with hardware not supported in Linux - nVidia of course). With btrfs snapshot before update - "rollback" could be done almost immediately. If I'm not mistaken OpenSUSE is doing it already automaticly.
- Likes 2
Leave a comment:
-
Originally posted by pal666 View Postbut you are advertising ext4 on lvm. btrfs outperforms that abomination
Leave a comment:
-
Originally posted by Girolamo_Cavazzoni View PostThanks for that input - how would you activate that in Firefox?
Always make a snapshot or backup of your files.- Close your application
- Open the db: sqlite3 somedb.sqlite
- Check current journal mode: PRAGMA journal_mode;
- Enable WAL: PRAGMA journal_mode=WAL;
- Compact db for good measure (not strictly needed): VACUUM;
- Likes 2
Leave a comment:
-
Originally posted by cen1 View PostFedora is getting their releases out so frequently and on time now that it stopped being exciting to upgrade. I say that in the most positive way.
Leave a comment:
-
Running it since beta with default BTRFS.
Awesome Fedora is awesome
- Likes 1
Leave a comment:
Leave a comment: