I'm coding an application that will be uploading and deleting many files, i usually just move the files to a folder in the server naming them with the row unique id
. But as i understand MySQL also lets me store binary data (files) when would this be a better choice?.
Please use solid arguments, like When
does using BLOB will mean performance
improvement?.
P.S: I'm using MyISAM if that matters.
Thanks.
UPDATE:
Related questions:
- Storing Images in DB - Yea or Nay?
- To Do or Not to Do: Store Images in a Database (thanks to Sebastian)
UPDATE 2
Storing the files in the database is
not a need i'm trying to know when
is this a better idea than storing
them in folders.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…