Why You Shouldn't Use SQLite - Hendrik Erz

A second limitation is the file system. File systems have been built with reasonable file sizes in mind. That means: The limit for the files are even smaller than the limits for hard drive sizes. And then there’s speed: If you need an overview over the data you have you *must* at some point query every single piece of data in the SQLite file, and the bigger that file is, the longer this will take.