I had an interesting time investigating a bug related to SQLite performance today, so I thought I'd share a thread.
A PicoShare user reported that it took 14.57 seconds to load their list of files.
I still didn't love the idea of storing the redundant file size, and I considered alternatively creating a virtual SQLite table.
But we'd still have to populate the virtual table still at app load time, which would take ~10s per GB of data
Hope you enjoyed following along! Here's the full PR with the fix: https://github.com/mtlynch/picoshare/pull/221
Michael Lynch's personal Mastodon instance