Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
btkaruna
Starting Member
8 Posts |
 Posted - 2005-12-06 : 00:40:58
|
| hi,Need to insert .wav or mp3 file into sql server.I need to store maximum of 2 or 3 min of file into the database.which format would the best storing as .wav or .mp3.I think storing mp3 in blob data would be best.Pl. give suggestion which would be of much help to me.Thanks in advancekaruna |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-12-06 : 01:04:57
|
If you don't need full quality, mp3 is fine. However, storing them in the DB is just silly. You are much better off storing them on the filesystem, filesystems are good for that sort of thing.This will :1. Make coding much easier2. Make it faster3. Make your media files easier to move around and manage4. Make your db smaller and easier to manage.Trust me on this one  Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
btkaruna
Starting Member
8 Posts |
Posted - 2005-12-06 : 02:05:34
|
| Thank you Mr.Merkin as wav files are bigger than mp3 i thought storing in mp3 would be better option.One more request as in oracle we have utl_file_directory to store file in oracle server directory.is there any parameter to define sql server as i need to store the file in the sql server database directory.Thanks in advancekaruna |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-06 : 03:55:57
|
| "i need to store the file in the sql server database directory"What is the application that is going to access this file? Windows app? Web app? Something else?Kristen |
|
|
|
btkaruna
Starting Member
8 Posts |
Posted - 2005-12-06 : 04:26:32
|
| It is windows Application using VB accessing Sql server |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-06 : 04:47:36
|
| Then store only the path of the file in the table and using File System object load mp3 file to VB componentMadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-06 : 04:51:59
|
| Probably a bit more of a problem unless there is a file server (or a web server) that is available to all users of the VB application and could store the files [as files!]Kristen |
|
|
|
tim123
Starting Member
6 Posts |
Posted - 2005-12-10 : 22:59:07
|
| Hi,I have a problem that is similiar with karuna. I need to bring .wav files to the internet. According to Damian, I should store these files in the file system. Damian, do you mean I should store these files in c:\Inetpub\wwwroot\ and the virtual directory of this web application?Also, I guess I have to convert .wav files to MP3 for faster loading on the client site. Can you show me how to do it?Thank you,Tim |
|
|
|
|
|
|
Inserting wav/mp3 into database