Originally posted by cen1
View Post
Announcement
Collapse
No announcement yet.
Fedora 33 To Be Released Next Week
Collapse
X
-
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;
- 2 likes
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.
- 2 likes
Comment
-
https://www.phoronix.com/scan.php?pa...58-filesystems
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!
​​​​​​
Comment
-
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?Last edited by S.Pam; 25 October 2020, 07:21 PM.
Comment
Comment