|
I am creating an email client that will contain email
messages. Now a message may have multiple large attachments. 1.)
Would the best way to store these large objects be in
an oid field? 2.)
I assume for performance reasons I should place these
large objects in a separate table called attachments. And create an attachments
table for each user? 3.)
Only when a user clicks on an attachment to open it,
should I use server side SQL functions like lo_export and lo_open to read the
data to a file stream for my application to deal with? Am I on the right track or can anybody recommend a better
solution? |
