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 |
|
dilan777
Starting Member
1 Post |
 Posted - 2008-01-24 : 22:35:37
|
| how store video files in sql database.Also i want to know cording part |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-25 : 09:42:16
|
| You can do it, but I would recommend you store a filepath in a VARCHAR column which points to the video. For many different reasons , including scalability & performanceJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-25 : 11:13:18
|
| http://www.aspfaq.com/show.asp?id=2149MadhivananFailing to plan is Planning to fail |
|
|
|
newsqlguy
Starting Member
13 Posts |
Posted - 2008-01-25 : 12:26:41
|
| the main issue you have to pay attention when storing video on separate files is transactions. you have to make sure your codew could handle atomicity between adding record to DB and create the file on the file system. also when deleting record from db you have to ensure delete from file system or you will end up having zoombie files / records in your system.If you decide to go with video in DB, please keep the videos in a separata table in with a reference in the main data table. so as not to make your record too large. |
|
|
|
|
|
|
how store video files in sql database