Hacker News Reader

The largest I've worked with until now is a bit over 0.5TB. It's still performing as well as if it was a few GB.

For those of us who haven’t had a few GB SQLite db, does it perform different to one that is a few MB?

A few MB would likely be fully in the OS buffer cache. I think you would see the difference when it no longer fits.