Last post May 14, 2005 04:49 PM by davidparker
May 13, 2005 04:19 PM|davidparker|LINK
I want to build a DNN VB module that will allow me to load a picture and an audio file (very small mp3 file).
Should the files be stored in a table or on the HD?
I would like to use a table, but would this be too demanding on the resoures of the db? What's the standard practice?
The pictures and audio files will be associated with a userID. Seems like I should use a table.
Any code examples that you could point me too would be nice.
May 13, 2005 05:16 PM|Caddre|LINK
Pictures and audio files are image files they are not stored in table space SQL Server creates an Arithmetic pointer to the file. In Asp.net 2.0 Microsoft have complete application to manage music files. Try the link below. Hope this helps.
May 13, 2005 06:22 PM|davidparker|LINK
Hi thanks for our response. Your link points to a comparison of SQL server and MSDE. I didn't find anything about handling audio files.
May 13, 2005 08:25 PM|Caddre|LINK
May 14, 2005 11:04 AM|davidparker|LINK
Thanks! The article looks very helpful. Have you tried to build this? How well would this translate into a DNN module?
I think I could use some of these concepts for my module: I'm trying to build a simple DNN module that'll will allow a user to load a picture of a cymbal (the one that goes crash) and an audio file of that cymbal. Then others can view details and hear the
cymbal's audio file. It's a free service to sale or trade cymbals. The url is cymbalexchange.com. I know. silly, but there's a need. And it will encourage me to build my skills.
Any suggestions would be great.
May 14, 2005 03:22 PM|Caddre|LINK
May 14, 2005 04:49 PM|davidparker|LINK