Move attachments data to its own table?

[Jason Pyeron]

On Sat, 20 Aug 2005, Joel Peshkin wrote:

> Rather than continuing this, I wonder if we should leave all the metadata 
> (filename, mime-type, submitter, ceration timestamp, etc...) in the 
> attachments table but migrate the actual attachment data (the "thedata" 
> field) to its own table containing only attach_id and thedata.   I don't see 
> any disadvantage of doing this and it could save a lot of trouble.
>
> Anybody have any opinions about this?

Very logical as far as I can see. That is how we store our video data.

Why was it done this way the first time?

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                      PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager             7 West 24th Street #100     -
- +1 (443) 921-0381                 Baltimore, Maryland 21218   -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.