December 12th, 2005, 11:58 AM
Best Way To Store Audio Files?
Hi. this is a really simple question: what is the best way to store (large) audio? I have done some reading about SQL BLOBs and, it looks like there is a way to do it in MS SQL but, i am wondering if just creating a folder on my hard drive and accessing the files there would be better? Has anybody done this and could you give me an idea of what is the most cost-effective way to move forward? Thanks!!
December 14th, 2005, 03:54 PM
From a database viewpoint, I would just store the path and filenames in the database.
The tricky part would be the placement of such files. If you plan to have thousands of files, you don't want to place them all in one directory and you'll need to be concerned with existing files with the same name. You'll also want to make sure the paths are not too long either if you plan to backup files to standard ISO CDs or DVDs.
Based on the solutions other people have implemented with similar problems, they have all used multiple directories such as the following:
December 15th, 2005, 02:45 AM
I use BLOB before too, is just too much trouble. After awhile I just design it to store the directory path of those audio, video file and give up on BLOB.
December 17th, 2005, 07:10 PM
I've stored images and mp3 files as BLOBs in DB2 UDB with no problem. We had a knowledgable UDB DBA at the time who set up the bufferpool and tablespace(s) correctly for storing this kind of thing. One classic ASP file to serve up the BLOB as any kind of content type. Worked really well and eliminated the headache of filepaths and storing on on a NAS so that two servers (one primary and one failover) could serve it up.
...because that is the way we have always done it. We've been doing it like that for 80 Years! (How do we change that mindset?)