CODEWITHSUNDEEP
mysql
rpat
rpat

Reputation: 279

storing mp3 files in mysql

I see that many people recommend not storing mp3 files as blobs. I did not get a clear explanation of why that is.

I have low traffic websites (10 hits a minute). So far I have stored image files in database tables as blobs. The only look up that I do on the image tables is based on a single primary key. The image rendering has not been terribly fast, but OK.

I now have a need to store music files. If I used the same mechanism as the images, it would be simpler. But I need to understand the implications of doing that.

I would appreciate some advice.

Upvotes: 2

Views: 8678

Answers (2)

HIREN KUBAVAT
HIREN KUBAVAT

Reputation: 1

BLOB is required for that but i think fetching the URL of mp3 song and then set as hyper link and to play a song in browser this code is necessary

Upvotes: 0

Evert
Evert

Reputation: 99523

Filesystems are meant for files, why wouldn't you store it there?

In MySQL it will be so much slower; you're saying 'it has not been terribly fast'. This will grow exponentially if load increases. You'll also likely need to load the entire BLOB into memory in PHP (if that's the front-end language you're using) which also causes issues.

Once you've done this, you'll especially notice it increases memory usage and the time it takes before the mp3 starts downloading/playing.

Upvotes: 4

Related Questions