[sqlite] storing blobs in a separate table

[Rael Bauer]

Hi,

I am aware that in sqlite for a given "entity" one should generally 
store blobs in a separate table to the other standard fields (such as 
text/number etc..)

So for maximum efficiency, in such a blob table, is there a problem 
storing multiple blob fields?

E.g.  data1, data2, picture, etc..

or should the blob table only have 1 blob field? (perhaps with a second 
field indicating what is stored in the blob, or store different blobs in 
different tables?)

Thanks

Rael

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users