Vote Up 0 Vote Down

storing mp3 files in mysql database

I want to upload my mp3 file in mysql database.Plz suggest me for datatype of mp3 file and database structure.
flag

Answers


Vote Up 0 Vote Down
Don't keep mp3 files in databes, in db store only path to this files. Mp3 files store in folder on server.
flag | link |
Vote Up 0 Vote Down
You can upload the mp3 as Binary data and store it as BLOB type but it's not recommended.
flag | link |
Vote Up 0 Vote Down
mp3 or otherwise large files with proprietary encoding should not be stored in a database. You should store a path to that file instead. The reason is simple. When storing large data in a database, you are actually adding an additional layer of processing when retrieving it. This slows things down if you think of 100 or more users accessing your website at the same time.
flag | link |
Vote Up 0 Vote Down
Avoid using blobs, put file meta information to mysql and the file into a system folder, meta info must contain the path of the file
flag | link |

Your Answer

Login before answering

Login with facebook