Andy,
I can state that SQLite easily went up to 100GB with zero issues for us.
We decided to change the structure of our database and we reduced our
database size as we didn't want to incur extra VPN costs. We also
realised we designed the database wrong and it had a lot of useless data
in...but thats another different story :)
I have heard people talking about 300GB SQLite databases and I have no
reason to doubt that SQLite would work. As Simon says, environmental
issues may come into affect before you hit SQLite limits.
I can't comment on large blobs as not sure what large is, 1MB, 100MB,
1GB?
Rob
On 7 Jan 2020, at 11:21, Simon Slavin wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
