New answers tagged blob
Following further testing it seems my problem wont be performance, but simply creating the table, as that many BLOB fields exceeds the maximum row size, and so I can't even create the table!! I got to about 47 BLOB fields before it gave up.
I've seen it done both ways. If you want to bulk up your database size just start using BLOBS. Pro's for storing documents in your database you're already storing your data there so why not a little more? (Only it's a lot more) a certain simplicity of access. Any request to read only has to go one place to access the document or thing Cons for storing ...
Top 50 recent answers are included