Hi Andy,
What are reasonable limits for size Sqlite3 database file and large blobs?
Here are some benchmarks on BLOB performance:
https://sqlite.org/intern-v-extern-blob.html
However, see the note here in section 4.1 about using the incremental BLOB
I/O routines so that you don't thrash your memory allocator:
https://sqlite.org/malloc.html#_computing_and_controlling_parameters_m_and_n
limits.html gives you the actual hard SQLite limits:
https://sqlite.org/limits.html
The default limit for BLOBs is 1GB, but you can raise or lower that value
at compile-time. The maximum is 2GiB.
The overall maximum database size is 140TB (128TiB).
Here are some more reports on using SQLite for BLOB storage:
https://sqlite.org/fasterthanfs.html
https://sqlite.org/affcase1.html
In reality you will be limited by your ability to find the BLOBs
efficiently. i.e. what other metadata your store with them and how you
index them. If your individual data items are larger than 1GB then you'll
probably need to look at storing the underlying data across several BLOBs.
Best wishes,
@ndy
--
andy...@ashurst.eu.org
http://www.ashurst.eu.org/
0x7EBA75FF
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users