2 ms·
SQLite has also measured the performance impact for storing larger BLOBs: https://www.sqlite.org/intern-v-extern-blob.html https://www.sqlite.org/intern-v-exte
by gizmo 4y ago
SQLite has also measured the performance impact for storing larger BLOBs:
https://www.sqlite.org/intern-v-extern-blob.html https://www.sqlite.org/intern-v-extern-blob.html
The verdict: storing blobs in the database is totally fine. Stable diffusion is totally compute bound, the overhead of storing a 1mb file in a sqlite db is miniscule.