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

Reply via email to