Storing wav files

  • There is a need in our project to store wav files associated with a particulat type of event ocurring. What is the best way to store such files in SQL ?

  • Your choices are to store the file in the file system and the name of the file in the db, or put the whole file into a blob. Do a search on the site for blob you should find several other threads. I like putting stuff in the db, most people like to use the file system. Steve Jones recommends (and I mostly agree!) that if you go with blobs you should put them in a separate db to decrease backup/restore time of the main data.

    Andy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply