On Wed, Oct 30, 2013 at 9:10 AM, Teg <t...@djii.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users