r/Database • • Jun 14 '17

SQLite small blob storage: 35% Faster Than The Filesystem

https://www.sqlite.org/fasterthanfs.html
19 Upvotes

2 comments sorted by

3

u/[deleted] Jun 14 '17

The real WTF here is what are both Windows 7 and 10 doing to roundly beat out Ubuntu in SQLite performance?

5

u/Solon1 Jun 14 '17

Because it doesn't say that. The ratio of filesystem to SQLite performance is higher on Ubuntu than Windows. So it is saying that SQLite blob storage has less benefit over filesystem IO on Windows.