| Author |
Topic |
|
derok
Starting Member
14 Posts |
 Posted - 2007-11-10 : 17:07:17
|
| Hi,I am using sql server 2000,can i store a video like .wmv in my database?thanks for any response... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-10 : 17:59:26
|
Yes. But why would you?How will you view it?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
derok
Starting Member
14 Posts |
Posted - 2007-11-11 : 09:49:50
|
quote:
Originally posted by Peso
Yes. But why would you?How will you view it?
E 12°55'05.25"N 56°04'39.16"
I am programing an visual basic .net application in visual studio .net 2003.And when the user asks for a video, i want it to be displayed.how can i save it in the database? |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-11-11 : 11:06:26
|
| I'm thinking that I'd store the video in a file and only store the file name in the database... could be wrong, though...--Jeff Moden |
|
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-11 : 12:12:48
|
| If you store it in a database, you should use IMAGE data typeHowever, I would rather save a link to a file |
|
|
|
derok
Starting Member
14 Posts |
Posted - 2007-11-11 : 16:01:09
|
quote:
Originally posted by evilDBA
However, I would rather save a link to a file
how do i do that? |
|
|
|
derok
Starting Member
14 Posts |
Posted - 2007-11-11 : 19:08:49
|
| do you guys have examples? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-11 : 20:10:49
|
| Just save file path and name in varchar column, need sample for that? |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2007-11-11 : 20:18:10
|
| Take the advice Derok, just don't do it.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
derok
Starting Member
14 Posts |
Posted - 2007-11-11 : 21:53:15
|
quote:
Originally posted by Merkin
Take the advice Derok, just don't do it.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson
why not? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-11 : 22:04:31
|
| Performance is one of the issues. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2007-11-11 : 23:34:41
|
| Performance is a big one, scalability is another.If you get a lot of videos, you're going to fill up your drive. If your files are stored on a fileSYSTEM you can simply change your app logic and put some on one volume, some on another volume.It's going to make your backups slower too, because you will be dealing with one huge MDF file rather than lots of smaller files.Can you imagine if youtube stored it's files in a database ? It's just kinda silly.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
Store video in database