Click here to Skip to main content
15,891,607 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
hi,

please could i have the code of how to upload an mp3 to a sql server database...
Posted
Comments
[no name] 30-Jul-13 14:22pm    
The sooner you start writing that code, the sooner you will have it.

1 solution

I wouldn't recommend it. My MP3's average out around 4MB each, and at that size database usage starts to mount up rapidly - which causes it to be slow to backup, slow to access, and so forth.

What I would do if store the MP3 file in a folder under a temporary name - a GUID is good - and store the location of the file and the original file name in my DB. That way, I don't tie up scarce resources like database connections while retrieving the files. Saving them also becomes a trivial operation - all you are storing is a couple of strings.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900