Base64 Encoded Data - DB or Filesystem
Posted
by
Marty
on Stack Overflow
See other posts from Stack Overflow
or by Marty
Published on 2011-11-21T17:41:23Z
Indexed on
2011/11/21
17:51 UTC
Read the original article
Hit count: 238
I have a new program that will be generating a lot of Base64 encoded audio and image data. This data will be served via HTTP in the form of XML and the Base64 data will be inline. These files will most likely break 20MB and higher. Would it be more efficient to serve these files directly from the filesystem or would it be feasible to store the data in a MySQL database? Caching will be set up but overall unnecessary because it is likely that this data will be purged shortly after it is created and served.
i know that storing binary data in the DB is frowned upon in most circumstances but since this will all be character data I want to see what the consensus is. As of now, I am leaning toward storing them in the filesystem for efficiency reasons but if it is feasible to store them in a database it would be much easier to manage the data.
© Stack Overflow or respective owner