On Wed, Oct 30, 2013 at 9:10 AM, Teg <[email protected]> wrote:
> I do keep the
> blobs in one table and meta-data in another.
>
Good point, and worth repeating.
If you store large BLOBs in your database, performance will be much better
if you keep them in a separate table something like this:
CREATE TABLE bigThings(id INTEGER PRIMARY KEY, stuff BLOB);
Then store all of your metadata in separate tables and reference the big
BLOBs using the short integer ID.
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
