On 7 Jan 2020, at 10:29am, Andy <borucki.andr...@gmail.com> wrote: > What are reasonable limits for size Sqlite3 database file and large blobs?
Unfortunately, recommendations (rather than hard limits) are closely tied to your OS and hardware. This is because the things you want to avoid are things like busting your cache, or memory faults, and the sizes of those are set by your own computer and OS. Experience of this list has shown that we really can't make any firm limits without knowledge of your setup, and you'd have to find someone with an identical setup to have a useful conversation. We can only urge you to test things out and see for yourself where your performance drops off. In terms of hard limits, you might like to read this: <https://sqlite.org/limits.html> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users