SQLite Forum

General question concerning database stucture and number of databases to use.
Login
I think you have figured out your answer to this part of the problem.  If you frequently update a data row without changing the BLOB, then it makes sense to store the BLOBs in a different table.